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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Bobriver7

  1. Bobriver7

    Connecting to MySQL using MyODBC

    Thank you I could finally get the DSN connection to successfully connect to the remote MySQL server using the hostname, username and password.. it succeeded. But, in VFP, creating a remote view requires the connection to connect to a database. when I use the database name in the DSN...
  2. Bobriver7

    Connecting to MySQL using MyODBC

    Hi Mike No, I just started to create the Data Source Name (DSN. during the DSN configuration, I filled the server name,database name, username and password. It should be that easy, but when you test the connection using a push button on that same configuration form, it fails with the message...
  3. Bobriver7

    Connecting to MySQL using MyODBC

    Hi all I am trying to connect to a remote Mysql Database using MyODBC , but it seems to fail to connect, any body has suggestions or better experience in connecting to web based MySQL Databases. Thank you Bob
  4. Bobriver7

    Record Order

    You can create a LOCAL VIEW of the table and set the ODER to RECNO() Decending, then use the view as the source for your list, easy and permanent without the (SET ORDER) confusion. Bob
  5. Bobriver7

    The REUERY() Function return value

    yes Mike thank you for the AERROR idea , it helped to expose the error which was a connection busy error. the solution was that I had to set the fetch size to -1 for all the other views. it's okay for this case because those views contain limited number of records. I don't know why I didn't use...
  6. Bobriver7

    The REUERY() Function return value

    Hi mike as I mentioned before, the problem appears on the client's computers and not on the development PC. my client is in a remote location and I have to test this on their location and I am waiting for them to arrange for this visit. I couldn't get somebody there to do the test for me...
  7. Bobriver7

    The REUERY() Function return value

    Thank you mike. the FetchAsNeeded property is .F. and it is stated clearly in the SQL statement when I (VIEW SQL) of the remote view on the view designer. to make sure of this i issued the requery statements as follows: MESSAGEBOX(REQUERY("ITDLIST"))...
  8. Bobriver7

    The REUERY() Function return value

    Hi I have a parameterized remote view on which I use the REQUERY() function. it works fine and retrieves the records normally but when I run the system on the client's computer it does not fetch any records.same data set, same version of vfp, SQL and everything. I checked the return value of...
See more

Part and Inventory Search

Back
Top