![Delphi-PRAXiS [en]](https://en.delphipraxis.net/uploads/monthly_2018_12/logo.png.be76d93fcd709295cb24de51900e5888.png){kind=logo}
Lars Fosdal
-
Content Count
3572 -
Joined
-
Last visited
-
Days Won
120
Everything posted by Lars Fosdal
-
D11 Update 1 + FireDAC + ODBC to Sage returning wrong data!
Lars Fosdal replied to Jasonjac2's topic in Databases
@Jasonjac2 I haven't read Cary's FD books, so I don't know if there has been any amendments? http://www.jensendatasystems.com/aboutcj.html -
I give up.
-
Quick, Good, Cheap - you can only pick two.
-
D11 Update 1 + FireDAC + ODBC to Sage returning wrong data!
Lars Fosdal replied to Jasonjac2's topic in Databases
CoInit/CoUnInit - Prior to starting DB components, and after the last disconnect I do this because I have zero control over what a DB driver does with regards to COM. -
D11 Update 1 + FireDAC + ODBC to Sage returning wrong data!
Lars Fosdal replied to Jasonjac2's topic in Databases
I thought ckForwardOnly was implicit when setting Unidirectional to true. When you look at the Monitor log - are all field types what you expect them to be? Personally, I always use CoInitialize(nil); CoUnInitialize; for projects that use a DB driver. Also when there is only a single main thread. -
Delphi (11.2) IDE stops after "All design time packages loaded", but works in admin mode
Lars Fosdal replied to rudy999's topic in Delphi IDE and APIs
Then I am afraid that uninstall/reinstall is the next alternative. Unless @eivindbakkestuen has some other idea? -
Can you rephrase that question? I don't understand it.
-
Escaping UK pound sign in JSON
Lars Fosdal replied to david_navigator's topic in Algorithms, Data Structures and Class Design
No. PS C:\Users\foslar> '£'|ConvertTo-Json "£" -
Such issues needs to be raised directly with EMBT. Noone here can assist in resolving them.
-
Delphi (11.2) IDE stops after "All design time packages loaded", but works in admin mode
Lars Fosdal replied to rudy999's topic in Delphi IDE and APIs
Is there a Nexus db connected component in one of the apps of yours, which is active at design-time, but which db cannot be reached from your PC? -
D11 Update 1 + FireDAC + ODBC to Sage returning wrong data!
Lars Fosdal replied to Jasonjac2's topic in Databases
This is indeed weird. Have you called CoInitialize(nil); CoUnInitialize; at start/end of app/threads? -
D11 Update 1 + FireDAC + ODBC to Sage returning wrong data!
Lars Fosdal replied to Jasonjac2's topic in Databases
Good point. I forgot about that since we don't use DB controls but feed regular grids from our query data. -
D11 Update 1 + FireDAC + ODBC to Sage returning wrong data!
Lars Fosdal replied to Jasonjac2's topic in Databases
I don't see any such limitation mentioned? -
Is it possible that an exception does not inherits from Exception class?
Lars Fosdal replied to Wagner Landgraf's topic in RTL and Delphi Object Pascal
I assumed any unmatched on-events would have been silenced. If E is nil - logging will be incomplete in some cases, since I pass the exception object to Eurekalog to capture a callstack for the log. It probably would be quite rare, though. -
D11 Update 1 + FireDAC + ODBC to Sage returning wrong data!
Lars Fosdal replied to Jasonjac2's topic in Databases
Not from the top of my head. I would definitively check the monitor to see if there is something enlightening in there? -
Is it possible that an exception does not inherits from Exception class?
Lars Fosdal replied to Wagner Landgraf's topic in RTL and Delphi Object Pascal
With TCP/UDP/Serial, JsonRPC, REST, Databases and conversions and partial data transfers possible - you tend to accumulate a number of these. -
Is it possible that an exception does not inherits from Exception class?
Lars Fosdal replied to Wagner Landgraf's topic in RTL and Delphi Object Pascal
When dealing with live data, there is no end to what can go wrong - so no - I do not have a small number of top level exception handlers. -
Is it possible that an exception does not inherits from Exception class?
Lars Fosdal replied to Wagner Landgraf's topic in RTL and Delphi Object Pascal
That is extremely significant. I have countless numbers of these and I am starting to wonder if they should be rewritten to try // ... except on E: Exception do begin end else raise; end; and then have a general handler for those further out. Or.... just log "An unidentified terrible event happened." -
D11 Update 1 + FireDAC + ODBC to Sage returning wrong data!
Lars Fosdal replied to Jasonjac2's topic in Databases
FDQuery.FetchOptions - Does changing Unidirectional to True have any effect? FDQuery.FormatOptions have a TON of settings, including map rules - which may solve encoding issues if the ODBC doesn't provide all the info that FireDAC wants. I.e. you can explicity specify the type of value that the db field should be translated to. From the Delphi Tools menu: FireDAC Explorer can help with experimenting with Format/Fetch options. FireDAC Monitor can also give good insight into the low level goings on when your application is running. Edit: I also wrote this a few years back: . -
D11 Update 1 + FireDAC + ODBC to Sage returning wrong data!
Lars Fosdal replied to Jasonjac2's topic in Databases
I was thinking along the lines of eliminating the way the 32-bit ODBC is used as the core problem for the Delphi app. The next thing I'd look at, would be encoding, language, locale issues. -
D11 Update 1 + FireDAC + ODBC to Sage returning wrong data!
Lars Fosdal replied to Jasonjac2's topic in Databases
@Jasonjac2 Do you get the same problems with the 64-bit ODBC and a 64-bit Delphi app? -
Best Practice Question: Bidirectional EXE-to-EXE communication
Lars Fosdal replied to Alexander Halser's topic in RTL and Delphi Object Pascal
Regular TCP telegrams are low cost, event oriented, cross platform, cross tool. The only hassle is identifying the port of the server, which typically would be a config setting. -
@milurt As timfrost wrote Your exception happens because you go from 0 to 70000 instead of 0 to 69999.
-
Async/Await with updating visual controls
Lars Fosdal replied to omnibrain's topic in OmniThreadLibrary
I do 🙂 Both to deliver tasks to worker threads, and to collect the updates and results. -
or ... GetMem(ballnumber, 7000); FillChar(ballnumber[0], 7000, 5);