Using $rv_starttime

[nsa]

Hi, I am not getting $RV_STARTTIME to insert as text into Access DB. $RV_STARTTIME is to be a simple way of having a unique identifier.

I would also like to use the same $RV_STARTTIME in the Record module .../$RV_STARTTIME.wav. This way we can match the recorded file against the record with the same $RV_STARTTIME. Simple but we do not require a complex app. survey_08.vgs

results.zip

[SupportTeam]

From looking at the script it looks like the problem would be in the module that loads the data into the MS access database (?).

 

The database fields are all text, so the SQL query must have quotes around each of the data items, like this:

 

INSERT INTO results (Date, Name_&_Location, Set1_R1, Set1_R2, Set1_R3, Set1_R4, Set1_R5, Set2_R1, Set2_R2, Set2_R3, Set3_R1, Set3_R2) VALUES ("$RV_STARTTIME", "$RV[Record_name]", "$RV[Get_Set1_R1]", "$RV[Get_Set1_R2]", "$RV[Get_Set1_R3]", "$RV[Get_Set1_R4]", "$RV[Get_Set1_R5]", "$RV[Get_Set2_R1]", "$RV[Get_Set2_R2]", "$RV[Get_Set2_R3]", "$RV[Get_Set3_R1]", "$RV[Get_Set3_R2]");

 

If you continue having problems please post a vgEngine trace capturing the call. The vgEngine traces can be found in VoiceGuide's \log\ subdirectory.