>>Hi Everyone,
>>
>>I'm working on a pilot project using the DreamWeaver UltrDev web application development tool and am trying to use a VFP database. I have the ODBC connection named and it tests fine. DreamWeaver however insists on putting a "." between the database name and the table name where VFP likes a "!". For creating recordsets (uses ADO), I can edit the actual SQL statement and put in the "!". For Inserts, I'm getting an error when trying to select the form columns for trapping user input for the insert statement. I don't even know if it has to do with the "!" or not.
>>
>>Anyone work with DreamWeaver and VFP? Any suggestions for those that might have would be appreciated.
>>
>>Thanks,
>>Steve
>
>Hi Steve,
>
>Yes, I have the same problem...tried everything I know but can't get it working.
>I emailed the Macromedia folks, and all they said was to use the advanced
>sql dialog and hand code sql and that the insert,update,delete features and other features closely tied in with the data bindings inspector will not work properly or at all. They also said to upgrade to Access. I said, "upgrade, are you absolutely nuts?" -- not much help there! Anyway, I like
>the tool, but is sure has some limitations using Fox data, as well as some
>other basic features that Interdev has. When I first read about it I really
>was excited at what they said was possible. I thought that maybe the problem was that VFP doesn't have an OLE-DB provider, but if you find something here I would really be interested in hearing from you. I'll give you a holler as well if I find a decent work around for this serious limitation.
>
>C-ya,
>
>John.

Hi John,

Nice to chat with you again. In creating recordsets, I noted the "advanced" option for writing the SQL. No problem there, retrieval works OK. But I don't note the "advanced" option for creating Inserts, updates, or deletes which means I can't seem to get to the code to write. A bogus workaround, but I wouldn't care if I had to write the SQL. Just can't find the place to do it for things other than retrieval.

I'll let you know what I come up with. Last night was my first night working with it so I have much to learn.

Steve