Hello Mike, Friday, January 20, 2012, 1:42:04 AM, you wrote: MS> thanks for file. Just a few minutes ago I sent to you the build where this problem fixed. ...
Hello, ... There was a problem with allocation of memory for very large set of strings, not a memory leaks. Also I rewrote the engine for xlsx and now the...
Forgot to add the note: I exported the first 1000000 records from your dataset to xlsx and Excel opened this file (takes 15 minutes to open there and 1 Gb...
Hello Mike, ... MS> The recordsets with billions rows are not splitted automatically as I wrote in previous message. MS> You need define the RowsPerFile...
Importing a txt (CSV) file. Check 1st row is a header Header Row 1 Start Row 2 The Headings do not appear on the File Preview - like they do for Excel,...
Hi, Mike. I've downloaded the last version of smdbgrid and now when compiling it says that property "Colcount" and "RowCount" does not exist. I had to go back...
Hello, these properties removed. Just ignore the warning in Delphi IDE when you open the form and save the dfm file. With best regards, Mike Shkolnik ...
Greetings... I am unable to import Microsoft Excel 2010 files using either the demo XLSviewer project or the SMImportFromXLS component. However, the compiled...
Hello, you need enable the SMI_USE_ZLIB directive in smi.inc file and recompile the SMImport package from sources Else the import from xlsx-files is disabled ...
Mike Scrolling through a grid (with "large" table), using the mouse wheel is really slow. Page up/down is fine, up/down arrows is fine; this is just for the...
Hi Mike Doesn't removing the // in front of {$DEFINE SMI_USE_ZLIB}in smi.inc and recompling SMImportD2010.dpk enable the SMI_USE_ZLIB directive? Thanks Bob...
Hello, ... Yes, it's enough. If you did it but not works anyway, just check if in search/browse path of Delphi IDE and/or your project you have the directory...
Mike, Sorry, I knew that OnDrawColumnTitle event is triggered, I would like to know what method / procedure / function to use to actually display /draw the...
Hello, you may call the inherited DrawCell method. By default, this method is in protected section but you may use the next code: type ThackSMDBGrid =...
Thank you for your reply, however when I used the sample code provided as a solution, my application got a 'Stack Overflow" error. Is there any other...
I used SMExport to export some data using the "MS SQL" format option. I can see the data if I open the xml file in notepad, but when I try to import it using...
When I export data to an XML file, I am unable to open the xml file using XML Notepad. I get the following error message. Error loading: B:\Data92;Test.xml '.',...
When I import data from an XML file that was created using SMExport with the "IE" or "IE Compact" formats, text fields that include a space are being...
When I use SMExport to create XML files and choose to use a text delimiter (which appears to be the default behavior when using the wizard), text values that...
Hello, do you use the standard QuoteTerm property for text qualifier? Or use the custom code in some event? I tried to reproduce this situation but all works...
Hello, your xml-file is not valid because string values for attributes must be quoted: <RECORD> <ROW CustomerID="Test001" Description="Test Customer 001" ...
Hello, do you use the Delphi XE or XE2? Please send to me privatelly (mshkolnik@...) the any sample of xml-file with this error. Seems like there is...
Hello, just define correctly the XMLTags property The xmlMSSQL format uses the another tag names and you need define these names in XMLTags property for...
I am using the QuoteTerm property for the text qualifier. I cannot replicate the problem today, so please ignore. If I see the problem again, I'll dig deeper...
I am using C++ in RAD Studio XE. I discovered my problem - I was using Windows-1252 encoding instead of utf-8. Changing to utf-8 allows me to open the xml...
Correction: I cannot open the xml file in XML Notepad regardless of the encoding I choose. I opened the xml files in a hex editor and discovered that the BOM...