0 Replies - 3797 Views - Last Post: 14 June 2012 - 09:06 PM Rate Topic: -----

#1 leixnt  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 30
  • Joined: 24-July 11

[FoxPro] Retrieve data from Db to Textbox

Posted 14 June 2012 - 09:06 PM

LOCAL lnConn,lnResult
lnConn = SQLCONNECT("book","root","")
   
sqlloadsj = "SELECT * FROM book WHERE no == '" + this.Value + "'"
   
   
   IF lnConn > 0
   		=SQLEXEC(m.lnConn, sqlloadsj,"_c_seek_f21810a")
   		SELECT _c_seek_f21810a -------> error here
   		MESSAGEBOX(sqlloadsj)
   ENDIF



im trying to edit connection on my old program (using mysql and want migrate to sql)
but im dont understand foxpro at all :D

i have 2 question here
1. Error says "Alias '_c_seek_f21810a' Not Found"
2. how can i attach data to textbox in foxpro using the code above?

any help would be appreciated..thanks

Is This A Good Question/Topic? 0
  • +

Page 1 of 1