Re: date

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

How to create a cursor object?

I dont have any VFP database. I am directly accessing table from Access
using connection string cnnSinaiRes (ODBC) as follows.

cSql = "SELECT agr_date FROM resident"
=SQLEXEC(cnnSinaiRes, cSql, "Resident")

"Christian Ehlscheid" <christian@xxxxxxxxx> wrote in message
news:%23FrSSqP0FHA.3568@xxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> if you're using a RemoteView you can force the type to date, the settings
> is
> somewhere hidden in the view designer under field properties.
>
> another option would be to use a cursoradapter and force the field to date
> by using it's "CursorSchema" property.
>
> Regards
> Christian
>
> "Wilson" <wilson@xxxxxxxxxxxxx> schrieb im Newsbeitrag
> news:434f3772$0$26571$afc38c87@xxxxxxxxxxxxxxxxxxxxxxx
>> Friends,
>>
>> I am usinng VFP8 and Access connecting using ODBC. Whenever a date field
>> (short date) is returned, it is in DATETIME() format. If I use format()
>> in
>> SQL command or TTOD() in VFP, then that field is not updatable. I also
>> played with format property and inputmask of the text box to hide time
>> portion. Nothing worked!
>>
>> My only intention is to hide the unwanted time portion displayed in the
> text
>> box while viewing or editing a date field.
>>
>> Any suggestions?
>>
>> Any
>>
>>
>
>


.

Relevant Pages

  • Re: Setting bind variables or defines from applications?
    ... Reopening cursors? ... we use ODBC (and running ODBC in ... Didn't hear of bind variables. ... returning a REF cursor? ...
    (comp.databases.oracle.misc)
  • Re: Multiple-step OLE DB operation generated errors.
    ... If you use an alternate database API (such as ADO or ODBC) rather than ... What is in fact happening is that the database server is, in some cases, ... downgrading or changing the cursor type from what was requested to something ... In the case of requesting a dynamic cursor, ...
    (microsoft.public.data.oledb)
  • Re: deadlocks when fetching
    ... >> It sounds like you are using a server side cursor. ... recommended in ODBC 3.0 and later. ... But as Andrew mentioned, check your cursor type. ... SQL Server generating a result set and pulling ...
    (microsoft.public.sqlserver.programming)
  • Re: General field?
    ... ODBC automatically convert a Memo field of any type to General. ... >>>I am using a memo field in a VFP8 dbf to hold a bmp file. ... >>> the resulting cursor is a 'General' data type. ...
    (microsoft.public.fox.programmer.exchange)