Navigation Menu

[Michael]

I have been working on this. It looks like it was originally intended to be added but appears to have gotten lost with all the other things that needed doing. I have succeeded in adding it to the Form Designer and am currently tracking down one last problem. I will let you know when I have something to test.

I am on holiday until the 1st of August, however, so it will be a while before I report back.

[Michael]

That is because the link objects only support 1:1 linkages on the form, and only links from the master table to other tables. You can have a detail block that links to the master table, and then within the detail block have further 1;1 links between the detail block master table and other table.

It might help if you describe what you are doing. The scenarios where you would need the sort of link you are trying to do are fairly rare, though we could look at how we support it in future if it were truly necessary.

[Michael]

Hi Dan,

I’m sorry you had to track all that down on your own. I have now installed a notification extension so that I get emailed when a topic is posted.

As for vola1base, that is correct, it won’t copy the internal record id (it may well be creating one of its own actually – though I would have to check to be sure).

[Michael]

Can you retest with the 2.02 release please. If it persists please email me.

• This reply was modified 7 years, 10 months ago by Michael.

[Michael]

This is an installer error. It should be fixed in the latest download.

[Michael]

If this is a new project, you need to make sure that the uisyshelp.sml is added to the project as a library and that the uisyshelphdr.sma is included in the project before this source file is included (the compiler is a one pass compiler, so constants need to be defined before they are used – therefore include file order can be important).

[Michael]

This should be resolved in the latest release. The problem was that the labelslib entry in the project file was not updated in the installer.

[Michael]

Are both forms using the same table object? When you open each form you need to pass to it a dring of datasources and an array of tables. That ensures that the same table object is used in each case. If you don’t, what can happen is that the record object from form 1 is not a descendent of the table object from form 2, which will cause that error. If you want to share records between forms, then they must be both referring to the same table object, not opening their own.

[Michael]

Hi Dan,

That is correct. In the 1.8 release we moved those from the sample code into the appframework, since there was no reason to make everyone have their own copy/version of them.

Ciao, Neil

[Michael]

Hi Dan,

The datepicker.sml was discontinued a while back and it was rolled into the uisyshelp.sml. That is why you are getting duplicate functions. You should probably stick with that one, which is already included in the appframework.sml, since it has been updated to support US-style calendar displays.

Ciao, Neil

[Michael]

Hi Giancarlo,

Does this happen just by starting Superbase, or by running your program? I suspect that something else is wrong somewhere else though, since we have Superbase running fine on 32-bit Windows 7, 8, 8.1, and 10 (other than the ever-growing number of printer driver issues for newer printers). I had a situation where the MSI support in my Windows 7 was not working and there simply was no solution. I ended up reinstalling Windows 7 and everything I use and it was finally working again.

Ciao, Neil

[Michael]

On 07/07/2014 03:28, Peter Barus wrote:
> Neil,
>
> Libre Office does that, with the csv files, maybe they use wxwidgets or
> something. Just a thought.
>
> What are your plans vis-a-vis "apps?" Is it, or will it be, possible to
> construct Android/iPad/etc-oid apps in SIMPOL?

Hi Pete,

Sorry about such a late reply, my email/news software didn't pick this up for some reason until now. The plan currently is to use
a JSON data server written in SIMPOL as a web server application and HTML5/CSS3/JavaScript for on the device applications.
Eventually we hope to generate much of that code automatically.

> I am switching PDAs, and amazed at the way Apple and Google are dividing
> up the market for every sort of intrusive "cloud" connection. Almost
> impossible to just have a smart phone or tablet that isn't plugged into
> some mega-corporation's data-suckers. Before I knew how to turn it off,
> all my contacts were slurped up by Google. I get the most spam from them,
> from my hack-victim email friends.
>
> Love to the family,

Love to you all from us.

Ciao, Neil

> Peter
>
> On Fri, 04 Jul 2014 07:28:50 -0400, Neil Robinson <neil@simpol.com> wrote:
>
>> On 06/05/2014 12:29, kromkowski wrote:
>>> It seems to be there probably is a better way to do this (but I don't
>>> know exactly what is happening – consider my email offer).
>>>
>>> pseudo code
>>>
>>> get first line with field names
>>>
>>> open the modify table and let user set the field types and indexes. (it
>>> happens at the end but it should happen up front.)
>>>
>>> save the empty table
>>>
>>> import the data into the proper table.
>>>
>>> JDK
>>>
>>
>> Hi John,
>>
>> Sorry about the late answer to this, my attention was elsewhere. I have
>> done a considerable amount of work on the CSV converter
>> over the last few weeks. It is in about as good a state as I can get it
>> without adding features like the ability to preview the
>> first 50 lines or so of content and then manipulate the column
>> information. I do have that planned as a future enhancement, but it
>> will be part of a larger release.
>>
>> Ciao, Neil
>
>

[Michael]

On 06/05/2014 12:29, kromkowski wrote:
> It seems to be there probably is a better way to do this (but I don't know exactly what is happening – consider my email offer).
>
> pseudo code
>
> get first line with field names
>
> open the modify table and let user set the field types and indexes. (it happens at the end but it should happen up front.)
>
> save the empty table
>
> import the data into the proper table.
>
> JDK
>

Hi John,

Sorry about the late answer to this, my attention was elsewhere. I have done a considerable amount of work on the CSV converter
over the last few weeks. It is in about as good a state as I can get it without adding features like the ability to preview the
first 50 lines or so of content and then manipulate the column information. I do have that planned as a future enhancement, but it
will be part of a larger release.

Ciao, Neil

[Michael]

On 23/06/2014 19:08, Daniel Jinks wrote:
> I think:
> IP = Intellectual Property
> I have no idea what IPR is. I saw that term used earlier also.
>
> -Dan

IPR = Intellectual Property Rights. In some countries, you can never lose your copyright if you are the author, but you can sell
the right to commercialize the work.

Ciao, Neil

[Michael]

On 24/04/2014 18:27, kromkowski wrote:
> When you import, everything is default to string type.

That is true. There is currently no code to detect data type during an import from a text file. In that case if you are doing it a
lot, you can use import merge to an existing definition.

> You get a chance to modify the table (add indexes, change types).

True.

> But it is pretty clear that those changes aren't really "totally effective" unless you do a reorg.

If you change data type and don't do a reorg, then SIMPOL is forced to use the data in the format that it currently finds it. That
could mess up indexes. If you change data type you really have to consider the ramifications. Worse is importing something like a
date or time, since internally they are stored as values. The same is true in Superbase. If you convert a string field containing
dates to a date field, you first have to update the database converting the date to a DAYS() value and store that in the field.
Then change the data type to date, then reorganize.

> For example, if you change a field to "integer" and index it, they are not indexed as if they are integers
>
> 1,2,10,98,1000
>
> but as if they are strings:
>
> 1, 10, 1000, 2, 98
>
> I am see many more issues, but I'll just stop here. And see what kind of response with this stuff.

If you add an index in the same step that you change the data type, without reorganizing, then this will happen. The only thing we
could do is to force a reorganize as part of the process.

Ciao, Neil

[Author]

Posts