Re: Question for our database-wizzards

[Sarah]

Here is a function to get the real column types. Pass it the ID of your 
database connection and the name of the table. Interestingly, where you 
say revDatabaseColumnTypes returns all STRING, I find that it returns 
all FLOAT.

function listColTypes pID, pTable
  put "describe " & pTable & ";" into dbQuery
  put revQueryDatabase(pID, dbQuery) into curID
  if curID is not a number then
    return "Query failed:" & cr & curID
  end if
  put empty into typeList
  repeat
    put word 1 of revDatabaseColumnNumbered(curID, 2) & comma after 
typeList
    revMoveToNextRecord(curID)
    if the result <> true then exit repeat
  end repeat
  delete char -1 of typeList
  revCloseCursor curID

  return typeList
end listColTypes
Cheers,
Sarah
[EMAIL PROTECTED]
http://www.troz.net/Rev/
On Wednesday, June 18, 2003, at 10:48  pm, [EMAIL PROTECTED] wrote:

I have got a MySQL database with a database, containing several 
columns. I would like to get the specifics of each of these columns in 
this database (Integer, VarChar, key, value, etc).

The revDatabaseColumnTypes function should do this, but only returns 
“string” for all columns. I already checked with Sarah (and checked 
her MySQL sample) but she also ran into ?this problem, so if anyone 
could give me a clue....

Warm regards,

Ton Kuypers


_______________________________________________
use-revolution mailing list
[EMAIL PROTECTED]
http://lists.runrev.com/mailman/listinfo/use-revolution