Hello Group,

I would like to use a variable in an update SQL

Public gcNext_Uniq

gcNext_Uniq = 451001830

UPDATE suniq;
SET nextuniq = &gcNext_Uniq;
WHERE TblName = 'Studemo'

Doesn't work.

How do I get the SQL to take a parameter?

UPDATE suniq;
SET nextuniq = 451001830;
WHERE TblName = 'Studemo'

Works fine

Thanks much
Jim