Search results

Somebody else can finish off mySportsDb?

Just thought I'd share .... Run the code "makexmlschema.p" to build the code to extract xml table details, run the program "sports.p" to create the xml files, open up Micro$oft Access and import the tables you want to document (the import adds a "row" to the end of the table name, just rename...

Timezone issues is probably near the mark as the servers seemed to work fine up to a timeout of around 10 hours when I tried to find just where the problem "pause" was. Our time zone being GMT +10. Despite what they think of us, I have a few friends from across the ditch :)

Monday morning is when the clocks are sync'd (NTP) and this week was just under a 1/2 second move forward for the servers (which is the largest for a while). What the Windows machines were moved is not logged. So very probable the clock/time sync had issues and caused the "READKEY PAUSE n." to...

Not everyone was in today, still trying to find out of we update our clock from a central source (and so may have gone backwards in both platforms). It was hard enough tracking down the exact command where the App was failing, trick now is to replicate it and find out why. Keep you informed...

sigh! The old IT solution - try turning your machine off an on and it works again. I'm going mad!

"Immediately? Or after a set amount of time? Note: I'm using 12.2 x64." - Immediately! Yeah I'm running x64. Same on Linux version.

lol your Strine (noun; the English language as spoken by Australians) is very good!

Good to hear from you Tom btw!

Both Windows and Linux, first noticed on Windows as my test platform. If I set the seconds to something realistic its fine but users being users .... Nothing in the manual to say there is a limit.

No running 12.2 - I don't get a compile error - don't get to enter a key either but a "-1" displays. Thats the problem, the code does not wait for a key but continues with lastkey set to -1. Was allowing users to set a timeout in minutes and somebody decided to set it to 24hours.

try this; READKEY PAUSE 86400. DISPLAY LASTKEY. What is the highest "PAUSE" seconds that does not break? Try running a second time with say 15000, and it works first time but not on a second run? Anybody else come across this?

Next version @TomBascom ;-) This was just a Q&D to get it working. When I have the urge again ....

As usual, if you have a suggestion please share!

Create a spreadsheet, select 60 columns and 36 rows, set background colour black, make the columns 0.92 wide and save as GameOfLife.xlsx. Put the spreadsheet in c:\Temp and run the OpenEdge.p code in AppBuilder (Windows). Its very slow (the interaction to Excel is the slow bit) but will get...

Thanks Rob, I also saw somewhere it done using a temp table to combine the _storagobject data but your suggestion is better I believe. You could also detail each file and area - Run on the Dojo again (can be cleaned up, but you get the idea); pv-Area pv-Result...

Output from the dojo; pv-Area pv-Result ----------------------------------- ----------- Employee 192 Inventory 8,446 Cust_Data 1,117 Order...

I'm surprised nobody picked me up on the "bad" code - all too nice perhaps? But you should never do a "next" before "last-of" processing ;-) Seems to work OK (if not a little slow) but only one DB at a time, prefix _storageobject, _File and _area with the DB name in case of ambiguity. Not an...

Now that I remember the tags; CREATE WIDGET-POOL. DEF VAR h_predicate AS CHAR NO-UNDO. DEF VAR h_qry AS HANDLE NO-UNDO. DEF VAR h_buffer AS HANDLE NO-UNDO. DEF VAR pv-TotalbyArea AS DECIMAL NO-UNDO INITIAL 0. DEF VAR pv-GrandTotal AS DECIMAL NO-UNDO INITIAL 0. DEF VAR...

Have not tried this but it could also be useful to see how the schema areas are being used; I'll let you know how it goes;