How to insert a multiple data in datagrid

[lemodizon]

Hello everyone

just want to ask on how to insert multiple data in a certain column when it is checked in the check boxes. thanks below is the script code in the save button. thanks in advance everyone

Code: Select all

on mouseUp
  
  
  ## this script is for radio buttons
  put the hilitedbutton of grp "ChargerType" into tselected 
  put the label of btn tselected of grp "ChargerType" into tselectedName
  
  
  put fld "DateField" & TAB & fld "UserNameField" & TAB & fld "AssetTagField" & TAB & tselectedName into tNewInputData
  
  
  ## Check if datagrid already has content:
  put the dgtext of grp "LaptopDataGrid"of cd "AssetCard"  of stack "ITWC" into tOldData
  
  ## New and first entry:
  if tOldData = EMPTY then
    put tNewInputData into tOldData
  else
    ## We ADD the data
    put CR & tNewInputData after tOldData
  end if
  ## Now set the new data:
  set the dgtext of grp "LaptopDataGrid" of cd "AssetCard" of stack "ITWC" to tOldData
  
end mouseUp

[bogs]

Heya lemodizon,
I don't think you can do it the way your imagining (least according to that picture). I think you'd have to have a separate table for laptop accessories, with columns for each item, then use a join to pull it.

I know I am saying that badly, but the BYU course has a good example of it in the 310 section, where they are talking about foreign keys and relational dbs.

In a relational data model, instead of putting all of the information into a single huge table, the data instead is grouped into smaller tables, each of which describes a single type of object or entity. For example, for Acme Co. we might have one data table for employees, another one for departments, and a third for projects.

It is relational, baby...

[dunbarx]

Hi.

What Bogs said.

Broadly, the dataGrid is a two dimensional "array" of data. If you use the "dgText", you have to think of that as tab and return delimited, sort of like a spreadsheet.

So if you extract the contents of the DG with the dgText, whatever you do to that dataset has to be formatted accordingly. To work entirely within a single "column" means to work entirely within a certain item of each line.

Do you see? if your dgText looked like this:

A B C
D E F
G H I

there would be tabs separating, say, "A" from "B". In order to work within a single column, you would (pseudo):

Code: Select all

set the itemDel to tab
repeat with y = 1 to the number of lines of yourDGText
  put y into item 2 of line y of yourDGText
end repeat

And you would end up with:

A 1 C
D 2 F
G 3 I

and then you could set the dgText of the DG to that.

Craig Newman

[lemodizon]

Thank you Bogs and Craig

i just revised my data grid into spreadsheet style since i'm still studying the data grid.

just want to ask on how to delete on hilited line in the datagrid and what is the function of the Edit behavior script on the datagrid.are they the same with edit script? thanks in advance

[bogs]

I wonder if 'selectedChunk' or 'selectedText' would work in that instance?
(* Disclaimer, I don't do much with DataGrids).

Alternately, from dg specific things, you might crack open the dictionary and look up -
DeleteLine
dgDataOfLine
dgHilitedLines
dgIndexOfLine
...etc.

[Klaus]

Check my answer on FACEBOOK.

[lemodizon]

Thank you very much Bogs and Klaus

[lemodizon]

Hello everyone,

i was able to delete per line using the dghilitedline and then dispatch thanks again.

i'm in the edit button i don't know on how to put the item via checkbox and radio button

thanks for the help i really appreciate it. thanks in advance

Code: Select all

## this is my  edit button script

on mouseUp
  
  put the dgHilitedLine of group "LaptopDataGrid" into tLineToEdit
  
  if tLineToEdit is a number and tLineToEdit > 0 then
    go to stack "LAPTOPINFO"
    set the label of btn "SaveButton"  to "Save Changes" 
    
    set the itemDelimiter to tab
    put line tLineToEdit of the dgtext of grp "LaptopDataGrid"of cd "AssetCard"  of stack "ITWC" into tData
    
    put item 1 of tData into fld "DateField"
    put item 2 of tData into fld "UserNameField"
    put item 3 of tData into fld "AssetTagField"
    put item 11 of tData into fld "CheckbyField"
    
        
  end if
end mouseUp

[Klaus]

As I answered on FACEBOOK:
####################################
Do you mean how to make your checkboxes reflect the YES/NO form the datagrid?
Then Mr. Boole is your friend!
...
set the hilite of btn "Dock Station" to (item 5 of tData = "Yes")
set the hilite of btn "Mouse" to (item 6 of tData = "Yes")
## etc..
...
The engine will first resolve everything inside of the parenthesis,
and this will resolve to TRUE or FALSE in your example.
Even if the items are empty!

You get the picture...
#######################################

[lemodizon]

Thanks Klaus and to Mr. Boole

[lemodizon]

Hello everyone

i'm confused in the edit button especially in the radio button hope you can help me thanks in advance

https://www.dropbox.com/s/zj32v11f40ky ... code?dl=0

[Klaus]

Hi Lemuel,

see Facebook!

I think you are making it more complicated than is is!

With radiobuttons in a group, we do NOT save the hilite of each button, we save the NUMBER or NAME of the hilitedbutton in that group. When setting this back later, LC knows that only THAT button is hilited in that group and all the other buttons are not.

Example:
We have a group of 2 radiobuttons -> Yes and No

We click Yes, then:
-> the hilitedbutton of grp "my radios" = 1
-> the hilitedbuttonname of grp "my radios" = Yes

So to "restore" the hilite in that radiobutton group, we can set the NUMBER or NAME of the button that we want to be hilited:
...
set the hilitedbutton of grp "my radios" to 1
...
OR
...
set the hilitedbuttonname of grp "my radios" to "Yes"
...
In both cases LC will hilite htat namely button and unhilite all the other button in that group.
That is the big difference to checkboxes.

Best

Klaus

[lemodizon]

Thanks Klaus, This is now working... i'm still working when i save it duplicates instead it remains. thanks klaus again.

[lemodizon]

hello everyone i'm in edit button script but when i tried to click save it delete the first line of the data grid. thanks in advance.

Code: Select all

on mouseUp
  
  
  if the hilite of btn "DockStationCheck" then 
    put "Yes" into tcheckDockStation     
  else
    Put "No" into tcheckDockStation
  end if
  
  if the hilite of btn "MouseCheck" then
    put "Yes" into tcheckMouseCheck
  else
    Put "No" into tcheckMouseCheck
  end if
  
  if the hilite of btn "HeadsetCheck" then
    put "Yes" into tcheckHeadsetCheck
  else
    Put "No" into tcheckHeadsetCheck
  end if
  
  if the hilite of btn "CableLockCheck" then
    put "Yes" into tcheckCableLockCheck
  else
    Put "No" into tcheckCableLockCheck
  end if
  
  if the hilite of btn "PhoneCheck" then
    put "Yes" into tcheckPhoneCheck
  else
    Put "No" into tcheckPhoneCheck
  end if
  
  if the hilite of btn "ExternalMonitorCheck" then 
    put "Yes" into tcheckExternalMonitorCheck
  else
    Put "No" into tcheckExternalMonitorCheck
  end if
  
  //---------------------------------------------------------------- 
  
  
  
  put fld "DateField" & TAB & fld "UserNameField" & TAB & fld "AssetTagField" & TAB & the hilitedbuttonname of grp "ChargerType" & TAB & tcheckDockStation & TAB & tcheckMouseCheck & TAB & tcheckHeadsetCheck & TAB & tcheckCableLockCheck  & TAB & tcheckPhoneCheck & TAB & tcheckExternalMonitorCheck & TAB & fld "CheckbyField" into tNewInputData
  
  put  tNewInputData  into  tOldData
  
  // when i set this it delete the first line in the data grid
  set the dgtext of grp "LaptopDataGrid" of cd "AssetCard" of stack "ITWC" to tOldData
  
  
  
  
  
  
  
end mouseUp

[Klaus]

Hi Lemuel,

you do not check if there are already data in your datagrid, so you overwrite the first (and oviously only) line every time! Do this:

Code: Select all

...
   put fld "DateField" & TAB & fld "UserNameField" & TAB & fld "AssetTagField" & TAB & the hilitedbuttonname of grp "ChargerType" & TAB & tcheckDockStation & TAB & tcheckMouseCheck & TAB & tcheckHeadsetCheck & TAB & tcheckCableLockCheck  & TAB & tcheckPhoneCheck & TAB & tcheckExternalMonitorCheck & TAB & fld "CheckbyField" into tNewInputData
   put the dgtext of grp "LaptopDataGrid" of cd "AssetCard" of stack "ITWC" intotOldData
  
   ## Check here and APPEND new data if neccessary! 
   if tOldData = EMPTY then   
      put  tNewInputData  into  tOldData
   else
      put CR & tNewInputData  AFTER  tOldData
   end if      
   set the dgtext of grp "LaptopDataGrid" of cd "AssetCard" of stack "ITWC" to tOldData
end mouseUp

Best

Klaus