PowerBuilder 6.5 / WindowsNT4 SP3
I am currently having a problem using the PFC Linkage Service to try and delete
rows from a linked datawindow. We are using Oracle 8.0.5 and what seems to be
happening is as follows:-
* We have several 'of_Regististered()' columns between the master and detail
datawindow - two of them are DateTime fields (datatype 'DateTime' to Oracle)
but we are only using the 'time' part of it.
* When the delete fires and pfc_n_cst_dwsrv_linkage.of_DeleteRows() tries builds
the 'Find' clause to find rows to delete from the detail datawindow it is
never finding anything.
* The reason for the 'Find()' failing is that the part of the find clause is
invalid (the part with the times in it)
Here's the line of code from the PFC function (of_DeleteRows())...
ll_row = idw_Requestor.Find (ls_find, ll_row, idw_Requestor.RowCount())
And here's what is in (some of) 'ls_find' when it fires...
ls_find = "cd_crew = 'BECKY' and tm_end = DateTime('01/01/00 10:00:00') and
tm_start = DateTime('01/01/00 09:00:00') and cd_dist = '1001'
etc...
As mentioned, the parts that fail are the datetime bits.
Has anyone experienced problems like this with PFC Linkage and time fields and
know how best to get around it?
Thanks,
Andrew Bate
Severn Trent Systems (UK)
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
