So the update_row() function in write.c only works on Jet3?
Or is the problem in the util?
I know update_row uses mdb_crack_row to get the fields which works with
Jet4 and then just updates the field's value and size according to the
bind pointers.. but the value it upates doesn't contain those extra
bytes .. can you further explain the differences and how to fix it?
Btw, on a side note, I have updated the parser and sql library to
implement basic UPDATE and INSERT commands with update_row and
insert_row. the UPDATE works good except the problem I told you. and
INSERT inserts but the table doesn't get updated..
Jeff Smith wrote:
Sorry for not responding to your first message. In short, the updrow tool is
quite
primitive, and currently only works on text fields in Jet 3 (Access 97)
databases. I had
never even taken a look at the tool before receiving your first message.
-- Jeff Smith
--- Avner Peled <avnerus@xxxxxxxxxxx> wrote:
Has no one else came across these issues? or no one is crazy enough to try..
I tried insert now too..and it does insert but it seems to insert it on
the top and not update the table def correctly, the table doesn't show
with the new row
Avner Peled wrote:
Hello!
I'm having problems with writing (for example using the updrow
application) in latest mdbtools cvs.
when changing a numerical value, the value and the value next to it
turn into garbage.
when changing a string value, the following things happens:
if my table, t_people, looks like this
id first_name last_name age zipcode
1 avner peled 21 9540
2 ... .... ...
and I enter
updrow avner1.mdb t_people "id = 1" last_name=shalom
then this:
0fdb 05 00 01 00 00 00 15 00 00 00 44 25 00 00 ff fe ..........D%....
0feb 61 76 6e 65 72 ff fe 70 65 6c 65 64 1c 00 15 00 avner..peled....
0ffb 0e 00 02 00
1f .....
turns into this:
0000 05 00 01 00 00 00 15 00 00 00 44 25 00 00 ff fe
..........D%....
0010 61 76 6e 65 72 73 68 61 6c 6f 6d 1b 00 15 00 0e avnershalom.....
0020 00 02 00 1f
when viewing the table after the update, last_name appears as "sao"
instead of "shalom"
it seems the update ignores the "ff fe" in the start of the string,
what is that anwway?
Any ideas? any help would be appreciated.
If anyone wants I will also post the nuber update which turns small
numbers into negative and very big numbers.
Thanks!
Avner Peled
avnerus@xxxxxxxxxxx
__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail
-------------------------------------------------------
This Newsletter Sponsored by: Macrovision
For reliable Linux application installations, use the industry's leading
setup authoring tool, InstallShield X. Learn more and evaluate
today. http://clk.atdmt.com/MSI/go/ins0030000001msi/direct/01/
_______________________________________________
mdbtools-dev mailing list
mdbtools-dev@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
-------------------------------------------------------
This Newsletter Sponsored by: Macrovision
For reliable Linux application installations, use the industry's leading
setup authoring tool, InstallShield X. Learn more and evaluate
today. http://clk.atdmt.com/MSI/go/ins0030000001msi/direct/01/
|
| 
