Ms Access Db

[nsa]

New to VoiceGuide. When using MS Access in other IVR applications we have been required to conduct a select query at the top of the script.

As the srcipt continued the user input variables are assigned to the corresponding MS Access variables.

At the end of the script we insert a new row with the new variables.

 

It appears with VG that it is not required to perfom a Select ALL query at the top of the script, rather, assign the VG variables to the GET Numbers Values and then do an INSERT statement at the end of the script.

 

In otherowrds... not sure how to go about starting as in this first attempt we have been unable to add the values to the next DB row.

 

Assistance would be great as I was unable to find a basic instruction in any docs so far.

 

Thanks.

[SupportTeam]

As the script takes caller through the various modules (Get Numbers, Play, etc) VoiceGuide automatically creates "Result Variables" which hold the data and those Result Variables (RVs) can be used later in on other modules (eg: Database Query etc).

 

eg: say you had 3 modules titled "Age", "Height", "Weight" then VoiceGuide would create RVs like this: $RV[Age], $RV[Height], $RV[Weight] which can be used in an SQL query like this:

 

INSERT INTO Customers (AgeYears, HeightCms, WeightKgs) VALUES ($RV[Age], $RV[Height], $RV[Weight])

 

or if the fields AgeYears, HeightCms, WeightKgs were strings not number firls then the correct SQL would look more like this:

 

INSERT INTO Customers (AgeYears, HeightCms, WeightKgs) VALUES ('$RV[Age]', '$RV[Height]', '$RV[Weight]')

 

 

If you still have problems please post your current script and we can help in fixing it up for you.