|
Iniciado por John Marrone, 24,jun. 2005 16:35 - 7 respuestas |
| |
| | | |
|
| |
Publicado el 24,junio 2005 - 16:35 |
Hi All I have created a view and I make a change to 1 field. But it does not take. Here is my code: vwEnt is Data Source HCreateView(vwEnt, Entries, "RaceID,HrsName,PostPosition,PrgNumber", "RaceID", "RaceID]='"+vcRaceID+"'",hViewLocking+hViewExclusive) // Browse the view HReadFirst(vwEnt) WHILE NOT HOut() // Insert your process here // Create the view vwPPL is Data Source HCreateView(vwPPL, PPLines, "HrsName,Date,RunStyle", "HrsName,-Date", "HrsName='"+vwEnt.HrsName+"'", hViewLocking+hViewExclusive)
// Browse the view HReadFirst(vwPPL) WHILE NOT HOut() // Insert your process here HReadNext(vwPPL) END HDeleteView(vwPPL) vwEnt.RunStyle = "LL" <--- I change this field HModify(vwEnt) <-- - I write it to the view HReadNext(vwEnt) END HViewToFile(vwEnt) <--- I save it to the file HDeleteView(vwEnt) Can anybody help?? Thanks John |
| |
| |
| | | |
|
| | |
| |
Publicado el 24,junio 2005 - 16:57 |
John, hViewLocking should do the trick. Raimund
Hi All I have created a view and I make a change to 1 field. But it does not take. Here is my code: vwEnt is Data Source HCreateView(vwEnt, Entries, "RaceID,HrsName,PostPosition,PrgNumber", "RaceID", "RaceID]='"+vcRaceID+"'",hViewLocking+hViewExclusive) // Browse the view HReadFirst(vwEnt) WHILE NOT HOut() // Insert your process here // Create the view vwPPL is Data Source HCreateView(vwPPL, PPLines, "HrsName,Date,RunStyle", "HrsName,-Date", "HrsName='"+vwEnt.HrsName+"'", hViewLocking+hViewExclusive)
// Browse the view HReadFirst(vwPPL) WHILE NOT HOut() // Insert your process here HReadNext(vwPPL) END HDeleteView(vwPPL) vwEnt.RunStyle = "LL" <--- I change this field HModify(vwEnt) <-- - I write it to the view HReadNext(vwEnt) END HViewToFile(vwEnt) <--- I save it to the file HDeleteView(vwEnt) Can anybody help?? Thanks John
http://www.invitec.com |
| |
| |
| | | |
|
| | |
| |
Publicado el 24,junio 2005 - 16:59 |
John, hViewLocking should do the trick. Raimund Hi All I have created a view and I make a change to 1 field. But it does not take. Here is my code: vwEnt is Data Source HCreateView(vwEnt, Entries, "RaceID,HrsName,PostPosition,PrgNumber", "RaceID", "RaceID]='"+vcRaceID+"'",hViewLocking+hViewExclusive) // Browse the view HReadFirst(vwEnt) WHILE NOT HOut() // Insert your process here // Create the view vwPPL is Data Source HCreateView(vwPPL, PPLines, "HrsName,Date,RunStyle", "HrsName,-Date", "HrsName='"+vwEnt.HrsName+"'", hViewLocking+hViewExclusive)
// Browse the view HReadFirst(vwPPL) WHILE NOT HOut() // Insert your process here HReadNext(vwPPL) END HDeleteView(vwPPL) vwEnt.RunStyle = "LL" <--- I change this field HModify(vwEnt) <-- - I write it to the view HReadNext(vwEnt) END HViewToFile(vwEnt) <--- I save it to the file HDeleteView(vwEnt) Can anybody help?? Thanks John
http://www.invitec.com |
| |
| |
| | | |
|
| | |
| |
Publicado el 24,junio 2005 - 17:19 |
I am already doing that. >HCreateView(vwEnt, Entries, "RaceID,HrsName,PostPosition,PrgNumber", "RaceID", "RaceID]='"+vcRaceID+"'",hViewLocking+hViewExclusive) <---- Any other ideals. Thanks Raimund John
John, hViewLocking should do the trick. Raimund Hi All I have created a view and I make a change to 1 field. But it does not take. Here is my code: vwEnt is Data Source HCreateView(vwEnt, Entries, "RaceID,HrsName,PostPosition,PrgNumber", "RaceID", "RaceID]='"+vcRaceID+"'",hViewLocking+hViewExclusive) // Browse the view HReadFirst(vwEnt) WHILE NOT HOut() // Insert your process here // Create the view vwPPL is Data Source HCreateView(vwPPL, PPLines, "HrsName,Date,RunStyle", "HrsName,-Date", "H rsName='"+vwEnt.HrsName+"'", hViewLocking+hViewExclusive)
// Browse the view HReadFirst(vwPPL) WHILE NOT HOut() // Insert your process here HReadNext(vwPPL) END HDeleteView(vwPPL) vwEnt.RunStyle = "LL" <--- I change this field HModify(vwEnt) <-- - I write it to the view HReadNext(vwEnt) END HViewToFile(vwEnt) <--- I save it to the file HDeleteView(vwEnt) Can anybody help?? Thanks John
|
| |
| |
| | | |
|
| | |
| |
Publicado el 24,junio 2005 - 17:23 |
G'day John I haven't got a solution but as a starting point it would be useful to test the returns from the hmodify and the Hviewtofile to see exactly where the error is, because at this stage we don't know if the data is actually getting into the view to then be written to the file. Regards Al |
| |
| |
| | | |
|
| | |
| |
Publicado el 24,junio 2005 - 17:51 |
G'day John I haven't got a solution but as a starting point it would be useful to test the returns from the hmodify and the Hviewtofile to see exactly where the error is, because at this stage we don't know if the data is actually getting into the view to then be written to the file. Regards Al Hi Al After the HModify(vwEnt) the value of vwEnt.RunStyle is "LL" like it should be. So the HViewToFile(vwEnt) is where it is failing. How do you debug that??? John |
| |
| |
| | | |
|
| | |
| |
Publicado el 24,junio 2005 - 18:00 |
Hi Guys I did not have RunStyle as part of my view when I created the view. I don't know why WD did not error when i wrote vwEnt.RunStyle = "LL". You woukd of thought I would of got an error. O well thanks for the help. I am due for my 2nd cup of coffee any minute now, then I should be fully awake. John
Hi All I have created a view and I make a change to 1 field. But it does not take. Here is my code: vwEnt is Data Source HCreateView(vwEnt, Entries, "RaceID,HrsName,PostPosition,PrgNumber", "RaceID", "RaceID]='"+vcRaceID+"'",hViewLocking+hViewExclusive) // Browse the view HReadFirst(vwEnt) WHILE NOT HOut() // Insert your process here // Create the view vwPPL is Data Source HCreateView(vwPPL, PPLines, "HrsName,Date,RunStyle", "HrsName,-Date", "HrsName='"+vwEnt.HrsName+"'", hViewLocking+hViewExclusive)
// Browse the view HReadFirst(vwPPL) WHILE NOT HOut() // Insert your process here HReadNext(vwPPL) END HDeleteView(vwPPL) vwEnt.RunStyle = "LL" <--- I change this field HModify(vwEnt) <-- - I write it to the view HReadNext(vwEnt) END HViewToFile(vwEnt) <--- I save it to the file HDeleteView(vwEnt) Can anybody help?? Thanks John |
| |
| |
| | | |
|
| | |
| |
Publicado el 24,junio 2005 - 19:01 |
That's what a lot of developers, included me, needs : a pot of coffee and a supporting forum like this. Regards, Teun. |
| |
| |
| | | |
|
| | | | |
| | |
|