Retrieving dicom tag info

    It works this way, expects single quotes start and end of Data.StudyInstanceUID in the string line.


    sql("INSERT INTO mytest VALUES ('"..Data.StudyInstanceUID.."')");


    Thanks for your help.


    Thanks

    akhsuser

    Hi Marcel


    If we have to insert or update multiple columns of a table is this syntax correct.


    Importconvertor0= sql("INSERT INTO mytable ('patientID','PatientAge','PatientSex','LastAccessTime') VALUES ('"..Data.PatientID.."','"..Data.PatientAge.."','"..Data.PatientSex.."','"..Data.LastAccessTime.."')");

    Looks Ok.


    If you start console.bat or better from the gui Modify - image (advanced), you can type such commands and try them out (Data would be the image that is shown).


    Or install zerobranestudio to be able to write and test bigger scripts.


    Marcel

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login