|
-
Nov 20th, 2000, 03:18 PM
#1
Thread Starter
Need-a-life Member
Is there any way to UPDATE, DELETE, or INSERT data in an MDB (actually it's a DBF which is vinculated to the MDB) through an SQL sentece? Am I clear?
Emiliano F. Martín
 If a post has helped you then please Rate it! (and give the user points he/she deserves by clicking on the  image).
Encourage the person who helped you to keep doing it, and give him the points he deserves.
MP3 Organizer: Freeware to logically organize all your MP3s.
-
Nov 20th, 2000, 03:45 PM
#2
Fanatic Member
..
Hi...
tell us (3 yr olds..) a bit more...
surprisingly sometimes we come up with ideas... though often babyish
-
Nov 20th, 2000, 04:00 PM
#3
Thread Starter
Need-a-life Member
It's hard to explain. But I'm making an app in SQL Server. All the data I need is on the SQL Server. However, as the app I'm making is an optimization of an old system (written in Clipper for DOS) we would like to have both system running until the "debug period" of my app is over. So, the UPDATES, INSERTS and DELETES would be "seen" in both systems.
There are two main problems. The first one is that we don't have the code of the old system, so we can not change it at all. The second one is that the SQL Server and the DBFs that the old system uses are in different networks and could not see each other. This is done for security purposes.
As I need my app to "UPDATE" (or whatever) both databases, I was thinking I could record the "queries" I make in my app, translate the "queries" (change the name of the fields and that stuff) and re-execute (at night) the "translated queries" so that the DBFs of the old system are updated.
Did I make myself clear??
Emiliano F. Martín
If a post has helped you then please Rate it! (and give the user points he/she deserves by clicking on the image).
Encourage the person who helped you to keep doing it, and give him the points he deserves.
MP3 Organizer: Freeware to logically organize all your MP3s.
-
Nov 20th, 2000, 04:32 PM
#4
Fanatic Member
6.5 or 7.0
sql 6.5 and 7.0 have the trace capabilities
where u can trace every single statement that went through
a db during the day and save that in a .sql file
Unfortunately, enterprise manager does a few small queries
of itself.. but everything should be in that file and
you can rerun the queries later
...
-
Nov 20th, 2000, 04:42 PM
#5
Thread Starter
Need-a-life Member
The problem is not how to make the "trace" or whatever. I have a little idea how to achieve that. The question is how do I get these statements (made during the day) to modify the other old DBFs. I don't know if there's a way to perform an UPDATE, for example, to change a DBF. And if it's possible... how?
Emiliano F. Martín
If a post has helped you then please Rate it! (and give the user points he/she deserves by clicking on the image).
Encourage the person who helped you to keep doing it, and give him the points he deserves.
MP3 Organizer: Freeware to logically organize all your MP3s.
-
Nov 20th, 2000, 04:43 PM
#6
Fanatic Member
..
ok... sorry to have given u a run around
I don't know
-
Nov 20th, 2000, 05:13 PM
#7
Thread Starter
Need-a-life Member
Ok, no problem. Anybody have any idea?
Emiliano F. Martín
If a post has helped you then please Rate it! (and give the user points he/she deserves by clicking on the image).
Encourage the person who helped you to keep doing it, and give him the points he deserves.
MP3 Organizer: Freeware to logically organize all your MP3s.
-
Nov 24th, 2000, 10:51 AM
#8
Thread Starter
Need-a-life Member
Emiliano F. Martín
If a post has helped you then please Rate it! (and give the user points he/she deserves by clicking on the image).
Encourage the person who helped you to keep doing it, and give him the points he deserves.
MP3 Organizer: Freeware to logically organize all your MP3s.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote