SQLColumns

mcsalsa · Post by **mcsalsa** » Sat May 12, 2007 6:12 pm

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,

Rook Zimbabwe · Post by **Rook Zimbabwe** » Sun May 13, 2007 4:21 am

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()

mcsalsa · Post by **mcsalsa** » Sun May 13, 2007 8:30 am

Yes, I'm using a registered version of PB.

SQLColumns_ is from the ODBC.DLL