Page 1 of 1

SQLColumns

Posted: Sat May 12, 2007 6:12 pm
by mcsalsa
Dear all,

I need to know all the properties of the columns from a table in an access table. I used the example in the topic: http://www.purebasic.fr/english/viewtopic.php?t=14174

to get the tables from a database.

But I need to use the SQLColumns to get the properties of all the columns, but I can not run it from PureBasic, does anyone has any example on how to do it?

Regards,

Posted: Sun May 13, 2007 4:21 am
by Rook Zimbabwe
I don't see any examples of that in the tutorials listed in the HELP file. Are you using a registered version of PB? :?:

Also do you know the SQL string you would use? You can poke a lot of info in and out with DataBaseUpdate()

SQLColumns

Posted: Sun May 13, 2007 8:30 am
by mcsalsa
Yes, I'm using a registered version of PB.

SQLColumns_ is from the ODBC.DLL