Tables-Date Field

[Lawrence Ward]

I tried entering data into a newly created table with a date field and SIMPOL Personal shut down. It’s had the same response twice in a row. It was the first record of my table.

[Michael]

Lawrence Ward wrote:
> I tried entering data into a newly created table with a date field
> and SIMPOL Personal shut down. It's had the same response twice in a
> row. It was the first record of my table.
>

Hi Lawrence,

Can you give me more information here? When you entered the date, what
format did you enter it in? Also, what format is recorded in the table
definition for the date field? I have had reports of this before, but
have never been able to reproduce the problem, so any inforamtion you
can give me would help, thanks.

Ciao, Neil

[JD Kromkowski]

Neil Robinson wrote:
> Lawrence Ward wrote:
>> I tried entering data into a newly created table with a date field
>> and SIMPOL Personal shut down. It's had the same response twice in a
>> row. It was the first record of my table.
>>
>
> Hi Lawrence,
>
> Can you give me more information here? When you entered the date, what
> format did you enter it in? Also, what format is recorded in the table
> definition for the date field? I have had reports of this before, but
> have never been able to reproduce the problem, so any inforamtion you
> can give me would help, thanks.
>
> Ciao, Neil

I thought my post here, showed how to create the issue
and how to fix it by adding index to date field saving and then removing
index to date field and saving all in the modify file dialog.

Newsgroups: sbng.programming.general
Date: Apr 24 2009 17:11:12

********
I create a new sbm and table.

Two fields.

Name String
Dates Date
No indexes.

I add a record but only put something in Name field and then Data|Save
no problem.

I then try to change the record by putting cursor in date field and
adding a date. Shut down.

I reopen Personal. I open table. I add index to date field. Save. I
remove index to date field. And save.

Now the table works and doesn't shut down on dates.

Consider this which I also been able to consistently duplicate.

I create a table with only ONE Field as Date type. No problems whether
or not I add index.

I create a table with first field a String and Second field a Date. Now
I get the same problems.

This is how I am creating the problem.

File|New>Table (doesn't matter whether you create a new .sbm datasource
or add a table to existing datasource.

Then you get the SIMPOL Desktop Table Definition (might want to change
"Desktop" in the caption; in fact, check out menu titles to entry
dialogs that appear in this sequence).

click Add Field button.
Enter "Name" and hit enter. It will by default be a string.
click Add Field button.
Enter "Dates" and hit enter. It will also by default be a string.
So click on grid cell for Data Type and change to "date". I then click
on next grid just to get cursor out of that space.
Then click on Save button.
Then click on Close button.

Now you will have table there. 3 fields show. Name, Dates, and
recid_ro_internal.

Now Data|Add

recid increments to 000000000001

Technically, I think the cursor should be put into Name cell. (trivial)
Type your name. Hit "Enter", to move you to next field.
Type you birthdate. "Month N, 19nn", it really does matter what format
you enter because when you hit "Enter" it will shut down.

Reopen Personal.
Open this offending table.
Data|Add
increment will now be 000000000002
If try to add something to that date field you'll get a shut down.

Reopen Personal
Open this offending table.

This time File|Modify>Table
You'll get the Table Definition.
Add index to the dates field. SAVE.
Remove the index to the dates field. SAVE
Close.

Data|Add

increment now 000000000003
enter "name" in first field. ENTER to get to second field.
enter date in second field. ENTER. it will not shut down.

SAVE or try to move to next or previous record, in order to get save dialog.

[Lawrence Ward]

The previous description was accurate. The data type used was date M/D/Y
with a leading zero for month. Initially three different date fields were
included. The first date field, identical to the others is where the
system crashed. The others did not. Also, if I entered data in other
text fields, there was no crash. My solution was to delete the initial
date field. As a result the others worked. (I determined that I could do
without the field.

However SIMPOL Personal is still crashing, Neil, even with the more recent
file.

It crashed in the form designer area when I used the Select All feature in
on the menu. Total shut down.

It also shuts down after an import regardless of file type (XML, CVS,
ASCII). The good news is that when started back up, the file import was
successful. It shuts down when you hit the directional arrows.

[Michael]

Lawrence Ward wrote:
> The previous description was accurate. The data type used was date
> M/D/Y with a leading zero for month. Initially three different date
> fields were included. The first date field, identical to the others
> is where the system crashed. The others did not. Also, if I
> entered data in other text fields, there was no crash. My solution
> was to delete the initial date field. As a result the others worked.
> (I determined that I could do without the field.

Thanks, I will try and reproduce that.

> However SIMPOL Personal is still crashing, Neil, even with the more
> recent file. It crashed in the form designer area when I used the
> Select All feature in on the menu. Total shut down.

I will have a look at that as well. The thing to probably explain here
is that if SIMPOL encounters a syntax error at runtime, the program
exits. There is currently no exception handling that can keep it going.
Most things in SIMPOL that can cause a normal runtime error, like
failing to open a file, take an error parameter, and should then fail
gracefully, though there may still be a few places where it fails
anyway, and I would like to remove as many of those as possible.

> It also shuts down after an import regardless of file type (XML, CVS,
> ASCII). The good news is that when started back up, the file import
> was successful. It shuts down when you hit the directional arrows.

OK, I will try that, thanks.

Ciao, Neil

[Author]

Posts