Mensaje
General information
Foro:
Visual FoxPro
Category:
Bases de datos, tablas, vistas, índices y SQL
Miscellaneous
ID de la conversación:
00810823
ID del mensaje:
00811339
Views:
10
>>REPLACE cdr.rate WITH rate ;
>>, cdr.charge with IIF(cdr.duration>0,rate*cdr.billdur,0) :
>>FOR empty(cdr.rate)
>>
>
>This doesn't help you with your question in any way but one thing that you may not realise (it took me a while to realise) is that REPLACE pays no attention to the alias of the field you are replacing.
>
>ie. REPLACE cdr.rate - the "cdr" is ignored by VFP. What replace actually does is replaces the fields in the CURRENT alias unless you have an IN clause. SO what is much better is :
>
>REPLACE myfield WITH myval IN myalias
>
Not true!

CREATE CURSOR test1 (f1 C(10))
CREATE CURSOR test2 (f1 C(10))
INSERT INTO test1 VALUES ("Initial")
INSERT INTO test2 VALUES ("Initial")
?test1.f1
?test2.f1
SELECT test2
REPLACE test1.f1 WITH "not current"
?test1.f1
?test2.f1
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Responder
Mapa
Ver