Re: Wingz & SQL Q

Posted in 1994

Bharat Shah — Wed, 5 Jan 94 9:47:56 EST — source: Informix-list mailing list archive (1991-1998)

} } Wingz/SQL Problem!... } } } This works: } } CALL DB:DBSend("select counter from table10 where (time >= 10);") } } } But this doesn't: } } ftime = 10 } } CALL DB:DBSend("select counter from table10 where (time >= ftime);") } } } Any Ideas? } } Jas. Try creating the entire string before the DBSend call using "&" operator. i.e. ftime = 10 sqlstring = "select counter from table10 where (time >=" &ftime &");" CALL DB:DBSend(sqlstring) Bharat