@cleez said in Select Database Group ID:
@Allister I definitely am a bit confused on how to do this from reading your post. So the only way to get the "Insert record" feature to work is to do some unintuitive methods?
Sorry, for the lack of explanation. I've created a example for you & everyone else who needs it. I threw this together real fast so it's not that neat but it gets the job done. :)
Make sure not to run it with "first run = true" more then once. (why I set default to false). This can be fixed with simple checks on the Group Table. Select --> if (groupname exist).. etc and then you can drop the resource bool.
@cleez said in Select Database Group ID:
Im not seeing how making a new table will allow me to write the data to my previous table I am trying to write to
on the "Show Database" you'll need to manually create the table. After that, the script will create the groups that's need (hard coded, or resourced friendly). If you have any questions about the example let me know! :)
Allister ☯
@Allister Okay I think I am getting what you are saying about the program making the groups as needed and putting the apprioprate data in there. This will only make the groups on the first run correct? Afterwards it will just put the data in the groups?
Also is it possible to copy and paste this script into one I have already created?
@cleez said in Select Database Group ID:
This will only make the groups on the first run correct? Afterwards it will just put the data in the groups?
Correct, or like I said you can have it check if the groups already exist, if they don't create them else it will create a Global Json Object. One thing I forgot to mention, when creating Global Json Object at run time, you'll need to change the spaces (if any) to "_" or "-" or completely remove them. This can be done with a split or regex or a replace.
@cleez said in Select Database Group ID:
Also is it possible to copy and paste this script into one I have already created?
Yes just open the project in a new BAS studio and you can copy the commands over. You'll need to edit each Database command and change the values & table since the scripts database ID's might be off. (Database Schema in the .xml at the bottom)
Allister ☯
@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(){ })}
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 ☯
@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 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
@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.
@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
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.
@andykaufseo I found an easier way
@cleez please share with us...
@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.
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...
@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.
@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.
