Before a record is inserted I need to do a couple of things to the record.
I need to create a GUID for the unique key. How do you generate a GUID in scriptcase? Help and forum search for GUID turns up nothing.
I need to set another field to a value that has been selected on a master form (application link) Can I use a macro to get a value on another form? Or do I have to set a global variable somehow? Maybe when a user clicks on a field, a global variable gets set? Is that possible?
Why would you need a GUID? If you need one, know GUID is a microsoft thing.
If you want to create a guid you can go to: http://stackoverflow.com/questions/4313422/generate-guid-in-windows-with-batch-file and find the info there.
Since you can call an exe in php (or even run a vb script) you should be able to get a guid.
If you are on windows you can use: http://php.net/manual/en/function.com-create-guid.php
A little bit of googling will help a lot…
If you use an application link you can simply call the other application with a variable in it or you can set a global variable.
Setting a global variable is stupidly simple [global_var1]=‘I am a global variable with some value’;
I suggest checking the basics of scriptcase, this is one of the basics.
No, a guid is just a unique identifier. This is one of the options:
<?php
function guid(){
if (function_exists('com_create_guid')){
return com_create_guid();
}else{
mt_srand((double)microtime()*10000);//optional for php 4.2.0 and up.
$charid = strtoupper(md5(uniqid(rand(), true)));
$hyphen = chr(45);// "-"
$uuid = chr(123)// "{"
.substr($charid, 0, 8).$hyphen
.substr($charid, 8, 4).$hyphen
.substr($charid,12, 4).$hyphen
.substr($charid,16, 4).$hyphen
.substr($charid,20,12)
.chr(125);// "}"
return $uuid;
}
}