[bluelotus]

Ritesh

Thanks. Got it.

I also want the SQL syntax for adding an autoincrement column to an existing table.

and also how to delete the autoincrement column in a table through sql query.

I want the syntax.

Thanks

Manish

[bluelotus]

I am searching for a timestamp, row num function.

The code

rstRecordset!FillFields = ifld

CANNOT be put after the do loop as it will then just perform the action on the first row of the table and leave the rest of the rows.

[bluelotus]

Peter

I can use a SQL Update query only if you can tell me the syntax for a row id or rownum in MySql.

Without this I cannot use a Sql update query as it will update the entire table if not prevented from doing so by a clause stating the rownum or rowid. I hope you have got what I am trying to say.

Yes the calculated value is to be written in the last field of the table DailyQCRed.

Please go through my first post again. After calculating the count of the non null fields (from 4 to 40 excluding the fields from 34 to 37) in a record, it is placing the count in the last field of the record.

This is done for every record. So if I do not have a rownum, the SQL Update query will affect the entire table even when it has to update record by record. In other words when say for ex the count of the fields in the first record/row is taken it should be put in the last fiel;d (named FillFields) of the table but a SQL Update query without the rownum clause will put the fig in all the rows in the last field.

That's the reason I used the update method and it is not working.

Thanks

[bluelotus]

Peter

Thanks for your reply.

Yes SQLYog is an interface. I actaully meant MySql only but the yog was dancing in my head so much that I wrote yog instead. I am very new to MySQL though not RDBMS.

Incase you come to remember the correct syntax please let me know. A very imp piece of work here is getting delayed becasue of this.

Manish

[Author]

Posts