-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
If that works for you, great, but sometimes depending on the data you
are working with (and the quantity of data you are working with)
revDataFromQuery may prove rather useless later on. I don't use it at
all, really, but again, if it works for you,
Thanks. I think I will avoid the second step through the mire of the record
set and just deal directly with the data as then I can see what I'm doing...
On 3/19/05 2:23 PM, "Mark Wieder" <[EMAIL PROTECTED]> wrote:
> Bill-
>
> Friday, March 18, 2005, 7:28:42 PM, you wrote:
>
> RevQueryDatabase(
Bill-
Friday, March 18, 2005, 7:28:42 PM, you wrote:
RevQueryDatabase() returns a recordset id which you then use with the
recordset functions to get and manipulate the data. RevDataFromQuery
gives you the data itself without opening a recordset.
B> I was using:
B> revQueryDatabase(tConnection,
I finally figured out why the SELECT LAST_INSERT_ID() sql statement wasn't
working.
I was using:
revQueryDatabase(tConnection, dbQuery)
Which doesn't give you data from the query but instead results in a useless
number that increments weirdly (useless to me anyway).
Instead all I had to do wos u
Bill,
If you want to get the last ID from a table in MySQL, use the following SELECT
statement, and put the result into a variable - which will be the last ID value
in that table:
SELECT id FROM tripulatnes ORDER BY id DESC limit 1
This selects the column: id from the table: tripulantes, and s
put revConnectionOfQuery("ConnectCrew") into tConnection
-- first escape error
if tConnection is not a number then
put "tConnection is:" && dbCUR into fld "Exec result"
exit mouseUp
end if
put "SELECT LAST_INSERT_ID() from tripulantes" into dbQuery
put revQueryDatabase(tConnecti