Re: Connect to dBase V files with ODBC?

Thanks for responding Cindy,

The statement I was using looks like this:
CREATE TABLE s_pt (patient_id c(15))

There are more fields in the final version but I wanted to simplify it as
much as possible during troubleshooting. It did not create anything.

What I've found out since is that the application on the other end, this is
a Palm Pilot application using Satellite Forms, creates the tables for me.
So I don't need to run the CREATE TABLE command at this point.

What I am up against now is that to prepare the data for synchronization
with the Palm I need to delete all the data from the tables. I am trying to
do this with the "DELETE FROM s_pt" command but it isn't being recognized,
or at least it isn't deleting records. However, I am able to query the
table with a SELECT statement and insert new records with an INSERT.

Thanks,
Linn

"Cindy Winegarden" <CindyWinegarden@xxxxxxxxxxxxxxxxx> wrote in message
news:%23K0K4PPBHHA.2328@xxxxxxxxxxxxxxxxxxxxxxx
Hi Linn,

What exactly was your Create Table statement? Did it create anything at
all? Are you able to read dBASE V tables via your ODBC connection?

Working with SQLConnect() and SQLExec in the VFP Command window, after the
failed SQLExec command have you issued AError(laError)? When you examine
laError in the Locals Window, what do the different elements of the
laError array say?


--
Cindy Winegarden MCSD, Microsoft Most Valuable Professional
cindy@xxxxxxxxxxxxxxxxxxx


"Linn Kubler" <lkubler@xxxxxxxxxxxxxxxxxx> wrote in message
news:uDkcHQDBHHA.4472@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

I'm trying to write an application using Visual FoxPro that will create
and manipulate dBase V files. Since VFP does not support this function
natively I thought I could use ODBC to perform the connection much like I
do to SQL severs and Access .MDB files. So I created a connection using
the Microsoft dBase Driver (*.dbf) and selected Version 5 as the database
version.

I then wrote a routine that uses sqlexec() to send a create table command
to the connection assuming it would create a *.dbf file, but it doesn't
work. I'm looking for help in how to manage this task. Does anyone here
have an suggestions? I've posted questions on the VFP programmers
exchange and the dbase.com How-to news groups but no one has been able to
help so far.

Any suggestions?

Thanks in advance,
Linn






.

Relevant Pages

  • Rmote view connect SQL Server
    ... When I use vfp 6 remote view is share connection but I ... I use command check it. ...
    (microsoft.public.fox.vfp.dbc)
  • RE: Dialin problem
    ... # /etc/ppp/ppp.conf File for dial out modem to ISP and Dial in modem ... # connection to this FBSD system. ... # it's default options profile set to, NO command echo ATE0 and NO ... Edit /etc/ttys to enable a getty on the port where the dialin ...
    (freebsd-questions)
  • Re: [SLE] Setting up DSL on SUSE 10.1
    ... I won't faint at command line. ... SUSE or Mepis and the non computer oriented PCLinuxOS. ... In some OS's such as MS's the network will be confiured and on. ... on the DSL connection? ...
    (SuSE)
  • Re: More ASP.Net Newbie Questions
    ... The Command is then what you're doing with this connection, ... In regards to your final point, making grids and controls in general do ... > Connection and Recordset objects into, like, 37 different things. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Select - SQL vs. SUM
    ... If you have to use an earlier version of VFP earlier than 9, ... >> also force VFP to read from the buffer with a new clause in the SQL ... >> The SELECT command doesn't move the record pointer in the grid's record ... >>> I have a grid whose recordsource is a table named _payments. ...
    (microsoft.public.fox.programmer.exchange)