sybperl-l Archive
Up Prev Next
From: Oliver Scheit <oscheit at quoka dot com>
Subject: How to Count Rows?
Date: Jun 2 1999 5:05PM
Hi everybody !
I'm having trouble ! Here's part of the script:
$dbrec = 0;
$dbrec = $q->ct_sql("select count (*) from my_table");
$dbrec++;
$q->ct_execute("insert into my_table values ($dbrec, 'Test')");
What I'm trying to do is:
Number Text
-------- ------
1 Test
2 Test
3 Test
I'm used to using dBase tables - there you can define an
auto-incremental Column.
Or just call Table.RecordCount using Delphi, etc etc.
If anybody could help me, I'd be grateful !
Thanx and greetings,
Oli
|
