Hello, most database engines (BDE, ADO, dbExpress etc) converts the empty string to NULL. So just remove the NOT NULL clause for your field or apply some...
6302
Hemantha
hemanthamuth...
Mar 22, 2013 10:56 am
Dear Mike, Do you have any component to check the current version of the .Exe file and get the new exe file if the version number is old. There is a component...
6303
Mike Shkolnik
mshkolnik
Mar 22, 2013 10:59 am
Hello, you may try the TSMWebUpdater component from SMInternet suite: http://www.scalabium.com/sminet With best regards, Mike Shkolnik http://www.scalabium.com...
6304
Steve Ayers
steve_comman...
Mar 24, 2013 1:10 pm
Thanks for your response, Mike, but I'm puzzled by my test results. Perhaps you can shed some more light. We have a customer that needs to update their...
6305
Mike Shkolnik
mshkolnik
Mar 26, 2013 7:43 am
Hello, you may add the custom event handler for BeforePost event for your dataset and there to apply the empty string instead NULL: begin with...
6306
Lawrence Tse
LTse@...
Mar 30, 2013 7:25 pm
Hi, I have some columns in my grid with the filter values selectable from a combobox that I initialized by setting the Column.Filterlist. When I select a value...
6307
Mike Shkolnik
mshkolnik
Mar 30, 2013 8:09 pm
Hello, check if eoFilterAutoApply flag included in ExOptions property With best regards, Mike Shkolnik http://www.scalabium.com...
6308
Lawrence Tse
LTse@...
Apr 2, 2013 6:40 pm
Hi, eoFilterAutoApply is set From: SMComponents@yahoogroups.com [mailto:SMComponents@yahoogroups.com] On Behalf Of Mike Shkolnik Sent: Saturday, March 30, 2013...
6309
John Kuiper
j.kuiper
Apr 4, 2013 1:55 pm
Hello Mike, SMDBGrid is working very well. Even the filters are working as it should. But how can I switch to another field in the filterbar with a keyboard? ...
6310
Jose Manuel Leyva Gar...
jmleyvag
Apr 25, 2013 7:10 pm
How can disable the case sensitive in filter in SMDBGrid? Best Regards JM [Non-text portions of this message have been removed]...
6311
Mike Shkolnik
mshkolnik
Apr 26, 2013 6:47 am
Hello, ... You may use the OnFilterApply event to process every filtered value (accept or not accept) With best regards, Mike Shkolnik http://www.scalabium.com...
6312
Jose Manuel Leyva Gar...
jmleyvag
Apr 26, 2013 1:07 pm
Hello, How can use this event (OnFilterApply)? Some sample BR ________________________________ De: SMComponents@yahoogroups.com...
6313
Mike Shkolnik
mshkolnik
Apr 26, 2013 1:52 pm
Hello, begin if Assigned(Field) and (Field.AsString = FilterString) then Accept := True end; With best regards, Mike Shkolnik http://www.scalabium.com...
6314
Jose Manuel Leyva Gar...
jmleyvag
Apr 26, 2013 2:41 pm
Thanks [Non-text portions of this message have been removed]...
6315
Jose Manuel Leyva Gar...
jmleyvag
Apr 26, 2013 3:16 pm
Not Work, I need when type SAM or sam the smdbgrid show all record that contain sam Sam sAm saM ________________________________ De:...
6316
Doug Chamberlin
dougchamberlin
Apr 28, 2013 6:54 pm
Mike's example was for case sensitive matching. For case insensitive matching try if Assigned(Field) and SameText(Field.AsString,FilterString) then Accept :=...
6317
Jose Manuel Leyva Gar...
jmleyvag
Apr 29, 2013 11:10 am
Thanks, but not working, i try with if Assigned(Field) and SameText(Field.AsString,UpperCase(FilterString)) or ...
6318
Mike Shkolnik
mshkolnik
Apr 29, 2013 11:49 am
Hello, if you want to compare the part of text (filter by substring in any position), you need use the Pos() function: Accept := (Pos(UpperCase(FilterString),...
6319
Jose Manuel Leyva Gar...
jmleyvag
Apr 29, 2013 12:56 pm
Yes, it is working 100% Thanks Best Regards JM ________________________________ De: SMComponents@yahoogroups.com [mailto:SMComponents@yahoogroups.com] En...
6320
Doug Chamberlin
dougchamberlin
Apr 29, 2013 1:16 pm
What you have is legitimate comparison logic so there are only a couple of other possibilities here: 1) The field is not assigned when you think it is. 2) This...
6321
Steve Ayers
steve_comman...
May 7, 2013 2:24 pm
Is there anything in the SMImport component that might filter some of the fields so that they are not available to be mapped? We have a case where this is...
6322
Steve Ayers
steve_comman...
May 7, 2013 6:55 pm
After further testing, we've figured out that the fields that do not show up in the wizard were added to the table after the import specification was initially...
6323
Mike Shkolnik
mshkolnik
May 7, 2013 7:23 pm
Hello, if Mappings property is empty, then all visible fields from dataset are available Else the end-user will see only fields which are included in Mappings...
6324
Steve Ayers
steve_comman...
May 8, 2013 5:42 am
Thanks Mike, that helps. We will find a way to add the new fields to the list without losing the existing field mappings. ~ Steve Ayers ~ From:...
6325
Mike Shkolnik
mshkolnik
May 8, 2013 6:04 am
Hello, you may use the OnAfterLoadSpecification event and add there all your new field names With best regards, Mike Shkolnik http://www.scalabium.com...
6326
Steve Ayers
steve_comman...
May 10, 2013 6:31 pm
Thanks. ~ Steve Ayers ~ From: SMComponents@yahoogroups.com [mailto:SMComponents@yahoogroups.com] On Behalf Of Mike Shkolnik Sent: Wednesday, May 08, 2013 1:04...
6327
Mike Shkolnik
mshkolnik
May 10, 2013 9:21 pm
Hello, today the new trial and registered packages released to support the RAD Studio XE4 (Delphi and C++Builder). The reg.user may send the request for update...
6328
Chuck Herndon
chuck@...
May 20, 2013 4:46 pm
Mike, We get the following error when using the import wizard on an xlsx file. "Invalid variant type conversion" - Chuck chuck@... Web site:...
6329
Mike Shkolnik
mshkolnik
May 20, 2013 7:10 pm
Hello, 1. what version of SMImport do you use? 2. do you get the error in preview grid? Or during import process? 3. if the error raised in import process,...
6330
Chuck Herndon
chuck@...
May 20, 2013 8:04 pm
... ver 2.67 ... As soon as I select the file, before the preview. ... The mappings properti is clear. 4. if you may, send the sample xlsx file to me ... I...
