PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

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