can I write code to update the tables on the be?

[mapat]

Record traversing on OnLoad event

hi,

On the OnLoad event of a form, is it possible for the program to traverse or go through every single record (maybe with a while loop)?? If so, please send me the exact syntax.

Also, I want to update the tables on the back end. Is it possible to this in the be file? Where specifically would I have to put the code?

thanks

 

[DannySeager]

What do you mean by Update the tables? Do you mean change the structure?

Yes you can but what do you want to do...

Can I also ask why... Will these be regular changes? Usually regular changes to a database strucuture points to structural problems.

 

[mapat]

No, I don't want to change the structure of the table. I just wanna update the value of a field.

I have a "tasks" table that has a "HowOften" and "NextScheduledDate" field. Let's say that the user filled up 'weekly' on the "HowOften" field. So whenever this "NextScheduledDate" = to today's date, this same "NextScheduledDate" has to be updated by 7 days, and so on.
I already know the SQL statement. The reason why I am asking you if I could do this from the be file is because it doesn't let me update the table from the front end file, and I think it is very reasonable to do this update from the be file.

 

[DannySeager]

The update should come from the Front end... all the backend should do is sit there and hold the data.

Why doesn't it let you update it? what have you tried? do you get any errors?

 

[mapat]

It gives me the following error: "unupdateable table" ,when I execute the fe using the runtime engine on a different PC from the one that I am working on, but it works fine on my PC (which by the way has ACCESS installed)

 

[Rabbie]

Is the path to to the BE defined correctly on the PC where you have the problems. Check that PC can write to the directory with the BE in.

 

[mapat]

reply

I think so. You are talking about the linking of the tables (the fe to the be) right? I assigned the path with the "Linked Table Manager", but I did this assignment on the computer I am working on, since the other ones don't have ACCESS (I'm using them with the runtime version).

 

[Rabbie]

In that case the runtime must be able to use the same route to the BE as works on your PC