|
Home > Archive > dBASE Web Applications > November 2006 > Type mismatch
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Claus Mygind 2006-11-13, 7:14 pm |
| Not really an internet question more in general programming but it is my web
app.
when trying to update a .dbf table in which I have a column type "DOUBLE"
This works
cSet = "RATE ="+37.50
This does not work:
cSet = "WEBADDEDIT='Edit', "
cSet += "RATE ="+37.50
Same Query used for both examples
q.active = false
q.sql = [update ]+cTableName+[ set ]+cSet+[ where DETAILCODE
=']+cLineKey+[']
q.active = true
| |
| Ivar B. Jessen 2006-11-13, 7:14 pm |
| On Mon, 13 Nov 2006 14:13:19 -0600, in dbase.internet,
Subject: Type mismatch,
Message-ID: <amlnvG2BHHA.1780@news-server>,
"Claus Mygind" <cmygind@tsccorp.com> wrote:
>Not really an internet question more in general programming but it is my web
>app.
>
>when trying to update a .dbf table in which I have a column type "DOUBLE"
>
>This works
>cSet = "RATE ="+37.50
>
>This does not work:
>cSet = "WEBADDEDIT='Edit', "
>cSet += "RATE ="+37.50
>
>Same Query used for both examples
>q.active = false
>q.sql = [update ]+cTableName+[ set ]+cSet+[ where DETAILCODE
>=']+cLineKey+[']
>q.active = true
Try the code below my signature.
Ivar B. Jessen
//-----
close tables
if file("setRate.dbf")
drop table setRate
endif
create table setrate(rate float(10,2), ;
webaddedit char(15), detailcode char(15))
insert into setRate values(30.00, "copy", "abc")
insert into setRate values(40.00, "delete", "def")
insert into setRate values(50.00, "cut", "ghi")
insert into setRate values(60.00, "paste", "jkl")
clear
cs = "webaddedit = 'edit', "
cs += "rate = " + 37.50
cl = "'ghi'"
q = new query()
q.sql = 'update setrate set ' + cs + ' where detailcode = ' + cl
q.active = true
q.sql = 'select * from setrate'
q.requery()
?
do while not q.rowset.endofset
for i = 1 to q.rowset.fields.size
?? q.rowset.fields[i].value,
next i
?
q.rowset.next()
enddo
q.active = false
//-----
| |
| Claus Mygind 2006-11-16, 7:13 pm |
| Ivar,
I am going to continue this thread in sql-servers ng
Claus
"Ivar B. Jessen" <bergishagen@it.notthis.dk> wrote in message
news:36ohl2hdgls0ueu
sa4677aar81bp6s95o6@
4ax.com...
> On Mon, 13 Nov 2006 14:13:19 -0600, in dbase.internet,
> Subject: Type mismatch,
> Message-ID: <amlnvG2BHHA.1780@news-server>,
> "Claus Mygind" <cmygind@tsccorp.com> wrote:
>
>
> Try the code below my signature.
>
> Ivar B. Jessen
>
> //-----
> close tables
> if file("setRate.dbf")
> drop table setRate
> endif
>
> create table setrate(rate float(10,2), ;
> webaddedit char(15), detailcode char(15))
> insert into setRate values(30.00, "copy", "abc")
> insert into setRate values(40.00, "delete", "def")
> insert into setRate values(50.00, "cut", "ghi")
> insert into setRate values(60.00, "paste", "jkl")
>
> clear
>
> cs = "webaddedit = 'edit', "
> cs += "rate = " + 37.50
> cl = "'ghi'"
>
> q = new query()
> q.sql = 'update setrate set ' + cs + ' where detailcode = ' + cl
> q.active = true
> q.sql = 'select * from setrate'
> q.requery()
>
> ?
> do while not q.rowset.endofset
> for i = 1 to q.rowset.fields.size
> ?? q.rowset.fields[i].value,
> next i
> ?
> q.rowset.next()
> enddo
>
> q.active = false
> //-----
>
>
|
|
|
|
|