Svn Help

Play Now

NeOn

Golden Oldie
Golden Oldie
Aug 12, 2003
845
0
153
Chatsworth Estate, Manchester
Hello,

I am curious to how you print tables out on SQL as I have tried to print the STD_Items out but there is no option for print as far as I can see.

Does anyone know what to do?

Thanks


p.s.

Sorry if I have posted this in the wrong place because it isnt really server help but at the same time its to do with SQL which is mir related.
 

KnightRider

Dedicated Member
Dedicated Member
Oct 30, 2003
107
1
45
u have too connect to the database and then use query to get information out of the database,

am not sure how too code it in delphi.

so to get all the information out of STD_Items you use "SELECT * FROM STD_Items" this will get all the information with out selecting which columes you like to view. If you like only too get centrain information out like the name of the item you just remove the * and put fld_name.

Hope this helps


http://www.sql-tutorial.net/ <--- some more info on
 
Upvote 0

NeOn

Golden Oldie
Golden Oldie
Aug 12, 2003
845
0
153
Chatsworth Estate, Manchester
u have too connect to the database and then use query to get information out of the database,

am not sure how too code it in delphi.

so to get all the information out of STD_Items you use "SELECT * FROM STD_Items" this will get all the information with out selecting which columes you like to view. If you like only too get centrain information out like the name of the item you just remove the * and put fld_name.

Hope this helps


http://www.sql-tutorial.net/ <--- some more info on

thanks but i didnt have any luck, its ok I opened it in MSAcess and printed it, that seemd to work :)
 
Upvote 0