Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Afriza

    Numeric macro with where clause in selectcmd

    Thanks Olaf Doschke, If you don't mind i need any references (articles url, books online, etc)to learn more how to use CAs with the many ways regards
  2. Afriza

    Numeric macro with where clause in selectcmd

    Hi Olaf Doschke, i've tried your code suggested but the error messages still occurs as "No value given for one or more required parameters" here is my code lnVar = 100 This.SelectCmd = "Select * From mytable WHERE _id = ?lnVar" Yes you are right, the value not the number but still string...
  3. Afriza

    Numeric macro with where clause in selectcmd

    Thanks to all for any helps, Especially to Mike Lewis your code suggested is work (use Transform(lnVar) and the value still numeric) Good Day [bigsmile]
  4. Afriza

    Numeric macro with where clause in selectcmd

    Hello, I need to use a cursor adapter in data environment and i try to get data with my below command and it's not works lnVar = 100 This.SelectCmd = "Select * From mytable WHERE _id = lnVar This.CursorFill() i've try to use lnVar = 100 This.SelectCmd = "Select * From mytable WHERE _id =...

Part and Inventory Search

Back
Top