Re: remote view
From: Leonid (leonid_at_NOgradaSPAM.lv)
Date: 11/04/04
- Next message: Robert: "Stop to Debug a program"
- Previous message: Sietse Wijnker: "Re: How to download a file?"
- In reply to: Mark McCasland: "Re: remote view"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 4 Nov 2004 11:19:19 +0200
I beleive that VFP (at least VFP6) is smart enough to deal with
RTRIM(somefield) correctly. There must be something more complex, sush as
REPLICATE("*",len(RTRIM(somefield)))
create cursor tmp (f1 C(5))
insert into tmp values ("AAC")
insert into tmp values ("BBBBC")
create database tmp
*create sql view tmp1 as select f1, replicate("*",at("C",f1)) as f2 from tmp
create sql view tmp1 as select f1, rtrim(f1) as f2 from tmp
use tmp1
brow
update tmp set f1="AAAC" where f1="AAC"
requery()
close data all
erase "tmp.dbc"
erase "tmp.dcx"
erase "tmp.dct"
Leonid
"Mark McCasland" <mmccaslaATairmailDOTnet> wrote in message
news:%235stFkgwEHA.3288@TK2MSFTNGP14.phx.gbl...
>I suspect you have something like
>
> SELECT RTRIM(somefield) in your query. When you change the parameter, the
> data length of the field in the first record selected is different when
> you
> issue the REQUERY. Can you post the SQL code you use to create the view?
>
>
> "sujeet" <sujeet@troopsoftware.com> wrote in message
> news:OxMf9jXwEHA.1292@TK2MSFTNGP10.phx.gbl...
>> hi all ,
>> actually i made a parametrized remove view from mysql server
>> now i open dis it works fine.
>> when i pass value in a variable wich is as a parameter in view
>> now i open again it works fine here too.
>> now i change value in variable and i call requery method
>> it shows "views defination has been changed."
>> can anyone tell me whatz going wrong with me..
>>
>>
>
>
- Next message: Robert: "Stop to Debug a program"
- Previous message: Sietse Wijnker: "Re: How to download a file?"
- In reply to: Mark McCasland: "Re: remote view"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
