Forum Replies Created
- AuthorPosts
- JD KromkowskiParticipant
I cannot get the whereclause = guigetsimplefilter( …) to work. I can’t figure out where the problem actually lies because source for sml is not available.
There error is object not found. I do not have access right now to my actual code. I will follow up
Maybe the best way to track it down would be to put some code using guigetsimplefilter() into the
quickreportsample project.So I added the following to debug
string test
test = qr.whereclause
test = guigetsimplefilter(filter = test)Error (21): Object not found
Error: a statement of function “guigetsimplefilter” was executed unsuccessfully
There is no source code available for the statementSo we’re clear I added the repguilib.sml to the project, so I can see that the function is available.
JD KromkowskiParticipantI tried to see how it work in the Business example, where it is used with labels.
unfortuantely
labeldef =@ openlabeldef(ends up being nul so that function apparently isn’t even working.
even when I opened up one of the customer labels slx (after fixing bad reference to datasource as X:\, it is not clear to me that the filter button on the labels works at all.
So, maybe you could release the source for the gui that handles filter for updates,graphicreports, and quickreports?
JDK
JD KromkowskiParticipantI can’t seem to get guigetsimplefilter() to work.
But the source code for reportlib.sml is not available so hard for me to see what the problem is.
JD KromkowskiParticipantOops. pasted wrong thing. Is guigetsimplefilter() the way to access the filter GUI?
I see that graphicreport1 has property allowuserdefinedfilter but I don’t see corresponding property for quickreport1 or report1?
PS Really wish all the help docs were accessible from IDE and that you could search them all at once.
JD KromkowskiParticipantOk, I found how and where the file is being saved.
You browse and find the .csv which is your source.
Then you type in for example "testimport"
It will be saved in C:SIMPOLbin
BUT it will not have an ".sbm" extension (which is why i could never find it.)
It will just be sitting there as:
C:SIMPOLbintestimport
So this is clearly a bug.
JD KromkowskiParticipantIt 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
JD KromkowskiParticipant?
On 01/17/14 12:16 PM, kromkowski wrote:
> On 01/17/14 7:24 AM, Neil Robinson wrote:
>> On 14/01/2014 21:38, kromkowski wrote:
>>> Given the recent activity here, what is status with the v1.8 release?
>>>
>>
>> I expect to have something around 2 weeks after the final sale of the IP.
>>
>> Ciao, Neil
>
> What exactly do you mean by "IP".
>
> And what does that time frame for "final" sale look like?
>
> JDK
>JD KromkowskiParticipantOn 01/23/14 12:12 PM, kromkowski wrote:
> I am not sure what are saying. I do open up the tables individually in
> advance. The bug is also reproduced in Personal. I showed you screen
> shots. If you have a form with detailblocks – it only works correctly
> if all of the tables used are in 1 sbm.
>
> If you can show me otherwise, please do.
>JD KromkowskiParticipantOn 01/20/14 9:12 AM, Neil Robinson wrote:
> On 17/01/2014 17:12, kromkowski wrote:
>> I see what you are saying. But that means there is definitely a bug.
>>
>> As I've tried to document, I can only get this to work IF I put all of
>> the tables in 1 .sbm. If I have separate sbms for each table and only
>> one datasource (i.e. the IP address and port number) the forms do not
>> properly show the data.
>>
>> Your appframe example does not use detailblocks in the forms. The only
>> way I can get a ppcs appframe thing working is if I put all of the
>> tables into ONE sbm.
>
> You either need to open the tables individually in advance and have them in the datasource ring for the application and the tables
> ring for the appwindow, or else the form will open them as long as it can find them.
>
> Ciao, NeilI am not sure what are saying. I do open up the tables individually in
advance. The bug is also reproduced in Personal. I showed you screen
shots. If you have a form with detailblocks – it only works correctly
if all of the tables used are in 1 sbm.If you can show me otherwise, please do.
JD KromkowskiParticipantOn 01/17/14 7:24 AM, Neil Robinson wrote:
> On 14/01/2014 21:38, kromkowski wrote:
>> Given the recent activity here, what is status with the v1.8 release?
>>
>
> I expect to have something around 2 weeks after the final sale of the IP.
>
> Ciao, NeilWhat exactly do you mean by "IP".
And what doess that time frame for "final" sale look like?
JDK
JD KromkowskiParticipantOn 01/17/14 7:13 AM, Neil Robinson wrote:
> On 15/01/2014 21:59, kromkowski wrote:
>> On 01/15/14 12:06 PM, Neil Robinson wrote:
>>
>>> When using PPCS, all tables are in one data source. When using sbme I typically put each table in its own sbm file, but I then
>>> have to open all the tables during system initialization, before opening any forms that require database tables.
>>
>>
>> But that is really no good, is it?
>>
>> Putting 15 or 20 tables all into one datasource! That means if
>> something gets corrupted or otherwise messed up in one table, everything
>> ends up being potentially messed up.
>
> You misunderstand. All of the tables are in separate *.sbm files, but when shared using PPCS, they appear to be from a single data
> source. When used directly, there is one data source for each table. When used via PPCS, there is one data source (the IP address
> and port number) and that contains all of the tables. At the server end, they are still all in separate files.
>
> Ciao, NeilI see what you are saying. But that means there is definitely a bug.
As I've tried to document, I can only get this to work IF I put all of
the tables in 1 .sbm. If I have separate sbms for each table and only
one datasource (i.e. the IP address and port number) the forms do not
properly show the data.Your appframe example does not use detailblocks in the forms. The only
way I can get a ppcs appframe thing working is if I put all of the
tables into ONE sbm.JD KromkowskiParticipantOn 01/15/14 12:06 PM, Neil Robinson wrote:
> When using PPCS, all tables are in one data source. When using sbme I typically put each table in its own sbm file, but I then
> have to open all the tables during system initialization, before opening any forms that require database tables.But that is really no good, is it?
Putting 15 or 20 tables all into one datasource! That means if
something gets corrupted or otherwise messed up in one table, everything
ends up being potentially messed up.JDK
JD KromkowskiParticipantshould I wait until v1.8 to explore this.
There definitely seemed to have been a problem using appframework and
PPCS with complicated forms where tables are not all put in the same
..sbm. (as was documented in this thread.)JDK
On 09/17/13 12:52 PM, kromkowski wrote:
> See attached and screenshots – the data in the files is sufficiently
> altered.
>
> I can "get around the problems" by putting tables into one .sbm. But as
> we discussed that really would be a corruption nightmare waiting to
> happen – when I actually move from this crude test with two tables to
> something more complicated with dozens of tables and 100000s of records.
>
> Thank you for your time.
>
> JDK
>
>
>
> On 09/17/13 7:21 AM, Neil Robinson wrote:
>> On 10/09/2013 15:52, kromkowski wrote:
>>> Well, Neil, then there is bug or there is something I am missing because
>>> only the mastertable data is shown in the form.
>>>
>>> I have Simpolserver RUNNING.
>>>
>>> In Personal
>>>
>>> I first open ppcstype1 datasource (using appropriate ip address and
>>> port) AND I open both tables EMPLOYEE and WAGES.
>>>
>>> Now, I try to open TestForm1.sfx. No errors, BUT only the mastertable
>>> data shows!
>>>
>>> This is same behavior if I do this pro grammatically. (mastertable data
>>> show but childtable data does not show).
>>
>> Can you send me the form and the tables please (no data is required –
>> you can use the command line reorganize.smp and tell it 0
>> records).
>>
>> Ciao, Neil
>JD KromkowskiParticipantAs I understand it the menu copy and/or control c is not actual hooked up
to anything. It is supposed to copy a RECORD. If you are in a field and
have selected something, control c (or left mouse copy) works to copy
selection to clipboard as it normally would. (presuming you are using
windows.)JDK
JD KromkowskiParticipantOn 10/07/13 3:20 AM, Giancarlo wrote:
> Question 2:
>>>with guisimpolserver.exe can I open and manage Superbase database (*.SBF)
>>>file?No. the simpol server works with the .sbm datasources and the table(s)
therein, not with SBFs.There is a utility to convert an .SBF to a Simpol database. Also
Personal has a utility to import .csv, ascii delimited or xml into a
simpol database. - AuthorPosts