Select Database Group ID

[cleez]

@Allister Alright cool, I tried to run it just to test and its saying

TypeError: Result of expression 'JSON.parse(P("basglobal", "JSON_GROUPINFO") || '""').ActiveAccounts' [undefined] is not an object. Line number:2 During execution of script { _sa(44666115); var group = (JSON.parse(P("basglobal", "JSON_GROUPINFO") || '""').ActiveAccounts.ID) if(group.length == 0) group = P("_bas_table_" + (1), "_last_group") VAR_NEW_RECORD_ID = _db_add_record(group, [2,VAR_USERNAME,3,VAR_PASSWORD], 1) _next_or_section(123113051,function(){ })} 

[Allister]

@cleez

Doesn't look like you created the Object for ActiveAccounts
Look on the example. OnApplicationStart ---> (close to bottom) ----> Foreach (GROUP_LIST)

var obj = [[GLOBAL:JSON_GROUPINFO]];
obj[([[GROUP_NAME]])] = {"ID": [[GROUP_ID]]};
PSet("basglobal", "JSON_GROUPINFO", JSON.stringify(obj));

In the example it selects all the groups in Group Table, then loops through them, parsing the line and "creating" the object for each group.

Allister ☯

[cleez]

@Allister Weird enough i was using the example without changing anything just to try it. IS it possible I didnt set the table up correctly? Should I just delete all this and start over fresh

picture of the code
http://prntscr.com/gshryu

[Allister]

@cleez

Hmmm. I downloaded and ran it. Worked for me. Did you run it fully with "First Run?" set to true?
https://i.imgur.com/XbyhOWK.gifv

[cleez]

@Allister Yea I set it to true, its goes as far as making the groups before it stops. Should I be manually making the database and table before I run the script(Thats what I did before I ran it the first time)

Screenshot
http://prntscr.com/gshvc7

[Allister]

@cleez
On the Data Manager ----> File ---> Delete All Data
Then run it like I did in the gif I added. to the post above.

The script will create the Groups & add the groups with the ID's to the "Group" table if First Run? = true. After, it will selected all records in the Group Table, create the Global Object & then add each Group to the Global Object as an Object.

There should be no need to manually create anything in the database since the script has the Database Name & Schema in the xml file. Try closing the BAS Studio & deleting the database in C:\Users\{YOURPCNAME}\AppData\Local\BasDatabases\Database.19545. Then restart BAS.

[cleez]

@Allister I think I figured out what I did wrong. The first time i ran it i didnt open the database so it could restart after opening the XML file. Then I ran the script for first time user etc and restarted the database. Im pretty sure somewhere in there I screwed something up for that profile.

I redownloaded your example and deleted the old database and reran it and it all worked this time around.

Thank you for all the help, im going to play around with this for the next few hours and if i run into trouble ill @ you

[Allister]

@cleez

Oh yes, if you open a new project with a database you need to restart that certain Studio (when having multiple BAS Studio's running). ^_^ I forget that sometimes too. In-fact I spent 2 hours on a project debugging the sucker only to find out that was the cause of all my problems.

[cleez]

@Allister Haha that sounds annoying, last night I spent a few hours wondering why my database wasnt using both columns until i realized you need to add text to the description part of the column string

[cleez]

@andykaufseo I found an easier way

[andykaufseo]

@cleez please share with us...

[cleez]

@andykaufseo Make a new function, inside that turn on http://wiki.bablosoft.com/doku.php?id=i_want_to_run_some_actions_on_start_one_time

inside of that you will use the "Create group" feature. That feature will create a group with an id with a variable called something like " new group id". Use the log feature and put in that new group id variable to capture that groups id.

Run it once and in the output on the bottom you will see the group id. From there copy and paste it into the "insert record" feature and you will be good to go.

[andykaufseo]

Really appreciate it but damn, this is not what i had in mind - too complicated to select a group ID. i think someone who built BAS should answer this question - it should be a simple thing and the Group ID should be listed somewhere - it seems like a big design error of BAS to have things like this missing...

[cleez]

@andykaufseo I agree it is a design error imo but my suggestion is simple, after you get the id you can delete the create group stuff. Well its a temp solution until they make it simpler.

[support]

@andykaufseo I didn't read all thread, but here is answer for original question.
You can insert only to new group, which is created with Create Group action.
Create Group returns group id, which can be used later inside Insert Record action.

There will be interface to search/edit/delete groups but later.