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!

  • Congratulations Mike Lewis 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. emilioantonio

    Unable to access db after upgrading to PSQL 9.50

    Hy all I successfully access tha data of a btrieve format database via the following ODBC DSN-less connection using Pervasive.SQL 2000 Workstation engine and VB6. ..... Dim adoConn As New ADODB.Connection Dim rst As New ADODB.Recordset With adoConn .Provider = "MSDASQL"...
  2. emilioantonio

    Run external program from VB6 applicatione error

    Hi all I developed a VB6 application that at a certain point runs an external program (Winvam.exe) with the following code: Private Declare Function CloseHandle Lib "kernel32.dll" (ByVal hObject As Long) As Long Private Declare Function WaitForSingleObject Lib "kernel32.dll" (ByVal hHandle As...
  3. emilioantonio

    kriging algorithm to grid x,y,z data

    Hy all I need to generate a surface starting from x,y,z data. I tried to find code about gridding kriging algorithm but so far i didn't succed. I would really appreciate any information, suggestion or examples thanks emilioantonio
  4. emilioantonio

    PervasiveSQL2000 slow data retrieving

    hi abaldwin Actually i realized that the more consuming time process is "order by" clause in the select statement. In fact without this clause, the query runs significantly faster (but, however, i need to order data) Looping through as well takes its time. At the moment i do not have the...
  5. emilioantonio

    PervasiveSQL2000 slow data retrieving

    hi folks, i'm developing a VB6 real-time 3d graphic application that retrieves, every 10 seconds, data from a Pervasive.SQL2000 SP2 server database through the following DSNless connection code: Dim adoConn As New ADODB.Connection Dim rst1 As New ADODB.Recordset dim curdb as string curdb...
  6. emilioantonio

    PervasiveSQL2000 slow data retrieving

    hi folks, i'm developing a VB6 real-time 3d graphic application that retrieves, every 10 seconds, data from a Pervasive.SQL2000 SP2 server database through the following DSNless connection code: Dim adoConn As New ADODB.Connection Dim rst1 As New ADODB.Recordset dim curdb as string curdb =...
  7. emilioantonio

    sql select statement troubles

    OK Zemp i got it
  8. emilioantonio

    sql select statement troubles

    Hi cmahon What i do not understand is how to grab with debug.print a statement built with PCC (Pervasive Control Center). Thanks emilioantonio
  9. emilioantonio

    sql select statement troubles

    hi zemp your code was exactly what i nedeed. I've got the PCC and i built the statement there.... but what do you mean "..grab it with a debug.print..."? Ciao Emilioantonio
  10. emilioantonio

    sql select statement troubles

    Hi guys i have to retrieve data from tables of an existing Pervasive database using, for example, the following statement ..."SELECT * FROM LITHOLOGY", CON the problem arises when the table has a composite name (i.e. DEVIATION SURVEYS"). In such a case a syntax error occurs when i run the...

Part and Inventory Search

Back
Top