kustra
|
Posted: 04/20/2004, 3:36 AM |
|
Hi, I am trying Codecharge and it seems to be prefect for our internal CRM WEB site. But we encountered a problem with Visual FoxPro datetime field. Codecharge does not generate correct code for handling this type of field.
I have read all topics on this forum about VFP, but there was no clear advice how to solve this problem.
Thanks in advance
Norbert
|
|
|
peterr
Posts: 5971
|
Posted: 04/20/2004, 11:48 AM |
|
Norbert,
Please see http://forums.codecharge.com/posts.php?post_id=27238 , then I recommend contacting our support at http://support.codecharge.com.
I guess that we assumed that the standard ODBC driver will handle this (convert the dates accordingly) but if anything needs to be adjusted for FoxPro then we will do so.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
Anton
|
Posted: 04/23/2004, 12:01 AM |
|
Has Norbert tried setting the server connection date format to {^yyyy/mm/dd HH:nn:ss} ?
The additional leading '{^' and trailing '}' should get to be inserted as part of the datetime format pattern and may allow a server working with VFPs ODBC to work.
Multi-row update inside the ODBC driver is highly unstabe (GPFs) and is to be avoided at all costs. Security and server stablity issues also exist and the driver has not been updated to cope with them.
A free 25 connection MSDE 2000 server may be a better way to go although I use a VFP conversion program to take all the RI database rules over into MySQL's InnoDB tables.
Anton
|
|
|
|