Sybase ODBC - Funky behaviour with MicroSoft Dbase Driver(ODBC) and PowerBuilder 9.02

Author

Funky behaviour with MicroSoft Dbase Driver(ODBC) and PowerBuilder 9.02

Cfauvel

2005-12-05, 8:23 pm

God help me, we have this stupid little dbase3 file that contains a 3
character column as the key and several other columns that are are datetime
fields (ytd_start, ytd_end, mtd_start,mtd_end)

The goal is to retrieve the records into a DW, Update the fields in the DW,
and delete the records from the DW and of course SAVE the changes.

The retrieve, update and insert seem to be fine.

it is the DELETE that is giving me troubles.

The DSN entry for this dbase3 file within the ODBC administrator window has
the setting Show Deleted Rows = 0, so I would expect that deleted rows would
NOT show up in the DW, however they do.

When I delete a row from the DW, within the IDE, and hit save and then
retrieve, I get the row back, however I know it is marked as deleted,
because when I open the DBF file in TEXTPAD I see the asterix in front of
the record.

For what ever reason the DW within the IDE brings back the rows marked as
deleted, but the executable version of the app works perfectly and DOES not
bring back the deleted rows.

I've also created a C#.net application to do the same thing, this app
retrieves the proper rows, inserts,and updates just fine, just doesn't mark
the records as deleted, as confirmed by opening the dbase file with TEXTPAD
and NOT seeing the asterix in front of the record.

Millard F. Brown III

2005-12-05, 8:23 pm

Have you tried the dbase driver that comes with PB?
--
Regards,
Millard [TeamSybase]
"Cfauvel" <TheFauvels@verizon.net> wrote in message
news:4394c111@forums
-1-dub...
> God help me, we have this stupid little dbase3 file that contains a 3
> character column as the key and several other columns that are are
datetime
> fields (ytd_start, ytd_end, mtd_start,mtd_end)
>
> The goal is to retrieve the records into a DW, Update the fields in the
DW,
> and delete the records from the DW and of course SAVE the changes.
>
> The retrieve, update and insert seem to be fine.
>
> it is the DELETE that is giving me troubles.
>
> The DSN entry for this dbase3 file within the ODBC administrator window
has
> the setting Show Deleted Rows = 0, so I would expect that deleted rows
would

> NOT show up in the DW, however they do.
>
> When I delete a row from the DW, within the IDE, and hit save and then
> retrieve, I get the row back, however I know it is marked as deleted,
> because when I open the DBF file in TEXTPAD I see the asterix in front of
> the record.
>
> For what ever reason the DW within the IDE brings back the rows marked as
> deleted, but the executable version of the app works perfectly and DOES
not
> bring back the deleted rows.
>
>
> I've also created a C#.net application to do the same thing, this app
> retrieves the proper rows, inserts,and updates just fine, just doesn't
mark
> the records as deleted, as confirmed by opening the dbase file with
TEXTPAD
> and NOT seeing the asterix in front of the record.
>
>
>

Cfauvel

2005-12-06, 11:23 am

I'll have to try that.

But my problem is I don't know how to get said drivers deployed to my users'
pc.

also I'd rather use the driver that comes with MDAC or Microsoft.

Chris
"Millard F. Brown III" <millard.brown@teamsybase.com> wrote in message
news:4394c61b$1@foru
ms-1-dub...
> Have you tried the dbase driver that comes with PB?
> --
> Regards,
> Millard [TeamSybase]
> "Cfauvel" <TheFauvels@verizon.net> wrote in message
> news:4394c111@forums
-1-dub...
> datetime
> DW,
> has
> would
> not
> mark
> TEXTPAD
>
>

Cfauvel

2005-12-07, 9:23 am

Ok using the datadirect driver that comes with PB for dbase files works
fine.

To install the driver on the clients' pcs we used an old PB install disc and
chose only to install PowerBuilder, we chose CUSTOM setup, and deselected
everything except for the ODBC drivers.

Then after that it was just a matter of using the ODBC administrator to
create a DSN entry.

My question is now, how would you NORMALY deploy the ODBC drivers to a
clients PC along with your application?

for the app you need the EXE and possibly PBDs and the PBvm and PBODBC dlls,
but what do you need to deploy for say DataDirect dbase driver? and where
would the files go? System32?

Thanks

"Cfauvel" <TheFauvels@verizon.net> wrote in message
news:4395c7e1$1@foru
ms-1-dub...
> I'll have to try that.
>
> But my problem is I don't know how to get said drivers deployed to my
> users' pc.
>
> also I'd rather use the driver that comes with MDAC or Microsoft.
>
> Chris
> "Millard F. Brown III" <millard.brown@teamsybase.com> wrote in message
> news:4394c61b$1@foru
ms-1-dub...
>
>

Sponsored Links