FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


VB6 and data reports





akshar
I was using VB6 and ms access to write an inventory system.
I discovered that while displaying selective inventory info my customer needs the serial number of each entry that is being displayed.
These serial numbers can not be stored in the database.

How do Idisplay such serial numbers in the data form?
pozzler
Hello,

I read your question several times but didn't manage to figure what the problem is about.
I understand that there are products which are stored in Access database, and to each product there is assigned one serial number. That SN is not stored in any of the table, but is computed based on other data, that is stored in the DB?
If the above is correct, you can simply create a raport with one field displaying SN calculation results (=output of a function that calculates serial number given some product data)

Cheers

Wojtek
S3nd K3ys
pozzler, I think you're talking about a 'key'. Wink

akshar, why aren't you able to store the serial number in the database? If it's dynamic, then you should be able to set up some kind of logic to pull the serials from the external souce and display them.
akshar
see this is the table invoice
c1 | c2 | c3
1.3 | abc | 5
2.6 | efg | 6
5. 9| yyy| 5

A user gives query: "Select * from invoice where c3=5"


so I want results to be displayed as

1) 1.3 abc 5
2) 5.9 yyy 5

Noticed 1) and 2)? How do I make them get displayed? If I store them in databse they get displayed as
1)
3)
Related topics
Blu-ray disc hits 100GB
Fantastico could be updated
DOUBLE HDD AND FTP
New Data confirms a big earthquake in Central US
How to recover MOST of scratched CD data discs
Ftp Connecting Data Socket Problem....
Image Processing in C++ by Shirish
Data Backup - Prevention Is Better Than Cure
Pig misunderstanding
Programming links, info, and tutorials
Web Reporting - AWSTATS
WINDOWS XP SYSTEM RESTORE....
how to connect vb6 to mysql remotely?
data mining
Reply to topic    Frihost Forum Index -> Scripting -> Others

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.