Blavatsky

Somebody gave me a two part solution.
Half of which was kindly mentioned here, so thankyou.
To reiterate.
A) turn off CONNECTION object property "CONNECTED" to FALSE
B) This part, which nobody here mentioned, sorry, was to add code to the Datamodule's "ONCREATE EVENT"
such as..
  FDac_Con1.Connected := True;
  fdqry1.Active := True;

I am a newbie, with wrinkled skin.....
Have a NICE DAY and please forgive my ineptness.

17 hours ago, Brian Evans said:

Since you never said what the compile time errors were not much anybody can do to help. Also since you mention runtime errors most would assume you already solved any fatal compile time errors. 

Actually, if you read the post both messages are there in black and white...
Not, the help I was looking for ... actually what you meant to say was run-time errors.
Compile-time and design-time are take to be the same thing.

I noticed that he used Delphi 10 in the book.
The Chapter 2, example on Paradox and FireDAC  does not seem to run correctly in Delphi 11 on win 10 Home.
Edition

At least it shows it is possible.
But, if smart people can barely do this stuff it is virtually impossible for neophytes such as myself.

1 hour ago, PeterBelow said:

If you have the query or connection active in the designer make sure to deactivate it before trying to run the app from the IDE.

Yes, I know but the main issue remains... the errors during compile

Somebody from Embarcadero kindly wrote me an app to do that.
I put about 900 images (jpeg )

Hi,
I was wondering if anyone has had luck creating or knows how to create a
Paradox in FireDAC Delphi 11 Ent. 32bit VCL App [ simple DBGrid project }
after dropping a FireDAC.Phys.ODBC.Wrapper component on the DM1 datamodule which is linked
to the mainform and mentioned in USES clause eg DM1;
I run F9 and get an error message.
The weird thing is the DBGrid populates at design-time after checking active in TQuery component, but,
things go downhill after hitting RUN-F9... as that when the error comes up.
I did notice in some project versions of the exe -file  it would run and appear to operate ok but an error  message came up as well which was disconcerting. The compiling error was a given.
So, can someone please help me get it to run without errors.
I have attached a zip file of the project which uses Delphi 11 user sample data
so you will have to redefine "ODBC Advanced " section to put in "path/driver info" in the Connection Component Editor by right-clicking on it to change it... part of the path statement... not too hard to do that, and, then TEST CONNECTION and then save. Then RUN.
code for "ODBC ADVANCED" section in Connection object on DM1 [design mode] should look similar to this

DriverID=538;Fil=Paradox 5.X;DefaultDir=C:\Windows\System32;Dbq=C:\Users\Public\Documents\Embarcadero\Studio\22.0\Samples\Data;CollatingSequence=ASCII;

So, I click RUN with debugger
first message...
Project Paradox_ODBC_Project3.exe raised exception class EODBCNativeException with message '[FireDAC][Phys][ODBC][Microsoft][ODBC Paradox Driver] The Microsoft Jet database engine cannot open the file '(unknown)'.  It is already opened exclusively by another user, or you need permission to view its data.'.

Second message...
Exception EODBCNativeException in module Paradox_ODBC_Project3.exe at 0035BB8D. [FireDAC][Phys][ODBC][Microsoft][ODBC Paradox Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.

both messages are very similar.
Don't forget to close all.... and terminate process.

Any help is always appreciated.
Blavatsky

Paradox_ODBC.7z

Hi Stano,

I changed delphi 5 project from ADOTable to ADOQUERY with order by 'subject' field
the sql string was a bit tricky but I eventually got it sorted.

now it starts from first image.

Just have to learn how to Migrate from D5 to Alexandria

cheers

Richard C

I remmed out some code and it compiled

SUE ME

have a nice day

to all the 'Bruce Lee' Programmers... the real ones that do like to help others...

Hi Stano,
BLOB field in accdb.
I like the fact that the old "Load DB" project can add ~ 1000 jpeg files by selecting a whole folder of jpeg files and then the program recursively adds them all to the accdb DATABASE in a few seconds.
I asked Embarcadero for a demo that does this and they were unwilling to help.

It is like being so close ... yet so far.

Normally, I buy components and ask people to help me write the necessary code.
Tony Whyman who kindly helped me so many years ago is busy working on other projects like Lazarus.

Hello Stano,
I will double check the reference to "ORDER BY' IN AN  ADO QUERY- I know about that but thanks.
The main question is migration from Delphi 5 to Delphi 11 [290] Alexandria
 

UNLESS OF COURSE THERE IS AN EASIER WAY USING DELPHI ALEXANDRIA DBIMAGE VISUAL COMPONENTS, AS A WORK-A-ROUND SOLUTION
FOR BULK LOADING DATABASE WITH A FOLDER FULL OF JPEGS.

HELLO,
HERE IS ANOTHER PROJECT

https://gitlab.com/liuhouer/PhotoBook


THAT WOULD BE NICE IF IT RAN ON DELPHI ALEXANDRIA

IT HAS 3 ERRORS ON COMPILE

###################################################################################

function DeflateInit2_(ZState: TZState; Level: Integer; imMethod: Byte; AWindowBits: Integer; MemLevel:
  Integer; Strategy: Integer; const Version: String; StreamSize: Integer): Integer;

// initializes the hash table (Previous[] will be initialized on the fly)

var
  S: PDeflateState;
  NoHeader: Integer;
  Overlay: PWordArray;

  // We overlay PendingBuffer and DistanceBuffer + LiteralBuffer. This works since the average
  // output size for (length, distance) codes is <= 24 Bits.

begin
  NoHeader := 0;
  if (Version  =  '') or (Version[1] <> ZLIB_VERSION[1] ) or (StreamSize <> SizeOf(ZState)) then
###################################################################################

ERROR MESSAGE
[dcc32 Error] MZLib.pas(2004): E2015 Operator not applicable to this operand type


ANY HELP IS APPRECIATED

RICHARD_C

HELLO TO ONE AND ALL...
FOR THOSE THAT HAVE THE INCLINATION
CAN WE FORM A 'CIRCLE' TO NUT OUT HOW TO RESURRECT MWA DB JPEG COMPONENT LIBRARY V1.8 FROM DELPHI 5 TO DELPHI ALEXANDRIA. [ I ALSO HAVE D2010 ENT.  BUT NEVER REALLY USED IT ]
WHY ?
BECAUSE ONCE THE MS ACCESS DATABASE IS FORMED YOU CAN USE IT TO LOAD 100-1000 IMAGES IN A VERY SMALL AMOUNT OF TIME.
 

WHAT HAVE I DONE SO FAR ?

I HAVE MANAGED TO USED DELPHI 5 ENTERPRISE AND MWA DB JPEG WITH A SPECIAL "LOAD DB" WHICH THE AUTHOR OF MWA JPEG , TONY WHYMAN, MADE FOR ME MANY MANY MOONS AGO ~2002.
THE PROJECT WAS ORIGINALLY WRITTEN FOR PARADOX 7 [ WITH MWA JPEG COMPONENTS] SO IT HAD TABLES WHICH DELPHI ALEXANDRIA NO LONGER USES, SO ADO OR SOMETHING ELSE IS PROBABLY THE WA\Y TO GO..

BUT, I HAVE FIDDLED AND GOT AN EXE USING ACCDB WORKING.  ON DELPHI 5 ON XP COMPUTER.
THE ONLY PROBLEM WITH THE EXE PROGRAM IS THAT THE LAST JPEG IS ENTERED  AS THE FIRST ENTRY IN THE DATABASE. I AM NOT SURE WHY THAT IS.
ANYWAY I WOULD LIKE TO HAVE THIS 'FEATURE' AT MY FINGERTIPS IN DELPHI ALEXANDRIA ON WIN 10 HOME EDITION 64BIT - TO WORK ON AN ANCIENT EGYPTIAN SCRIPT PROJECT LATER AND OTHER LANGUAGE STUFF.

I HAVE A ~MONTH TO DO SOMETHING BEFORE MY GOVT TRIES TO FRY MY BRAIN. 6TH MAY 2022 IS THE HEARING DATE.

I HAVE COME ACROSS SOME INTERESTING STUFF

JEDI VCL - I do recommend to create restore point before loading JEDI STUFF as it is virtually impossible to uninstall if something goes wrong.
unRXLIB 4 - I think this fellow lives in Ukraine. I made a PDF for installing it.
NativeXML - XMLeditor demo looked interesting not sure if I got it working ... one of the PAS files was missing.
NativeJpeg - I got the viewer demo working after playing around with it.
GR32 - linked to NativeXML project I think
ZLib - linked to NativeXML project I think

Deleaker - might need some evolution to suggest fixes for leaks ... still in its early stages
FastMM5 - nice work 15 % faster apparently
Penganza Analyzer I think this acts like a USES wizard not sure about that.
Revo Uninstaller is good for reloading Delphi as its uninstaller is below PAR IMHO

Paradox Data Editor was OK to convert paradox to MS access
RAD & INSTALLER

SOMETHING ON HUFFMAN TREE - PROGRAMMING REDUCTIONISM/ INFORMATION COMPRESSION WHERE ENTROPY IS USED AS A METRIC FOR EFFICIENCY
WHERE EFFICIENCY = ENTROPY [h] IN BITS / LENGTH IN BITS 
 

CHEERS
RICHARD C

Hello,
I was wondering if Nils is OK after 2009 accident falling off a horse and having a stroke ?
I was also wondering if anyone has had any success running his SimLib (NativeJPG / NativeXml on Delphi 11) namely the "XmlTest" Demo project....
I did get one of the demos working "Viewer32"

When I run

I sincerely hope he is well.


Kind regards


Richard

from Down Under.

On 6/25/2021 at 6:43 PM, Ondrej Kelle said:

Years ago I wrote the "JEDI Uses Wizard" which scanned compiler messages to "catch" unresolved symbol errors and offer adding appropriate units to the uses clause. With no official OpenTools API available, it had to use a hack to retrieve the compiler output from the message window's treeview.
The code is very old and perhaps a bit dangerous (although back then it seemed stable) and I have no idea if it still works today (the IDE internals might have changed). See if it helps you:
https://github.com/project-jedi/jcl/blob/master/jcl/experts/useswizard/JCLUsesWizard.pas

Hello Ondrej,
Has there been any new work on Jedi Uses WIZARD ? How do you use it exactly ?
I tried compiling it (D11 JEDI 2.8 and 3.5) but it mentioned something about first getting  a DOC-O-MATIC filename.... What does that entail ?