Locating and reading database records using a CitectSCADA database device

Using CitectSCADA > Using Devices > Formatting Data in the Device > Locating and reading database records using a database device

To read data from a dBASE or SQL database device, use the DevFind() function to locate the record, and then the DevGetField() function to read each field:

FUNCTION

GetRecipe(STRING sName)

	INT hDev;

 hDev = DevOpen("Recipe");

 IF hDev >= 0 THEN

			IF DevFind(hDev, sName, "NAME") = 0 THEN

				PLC_Water = DevGetField(hDev, "WATER");

				 PLC_Sugar = DevGetField(hDev, "SUGAR");

				 PLC_Flour = DevGetField(hDev, "FLOUR");

				 PLC_Salt = DevGetField(hDev, "SALT");

					 PLC_Yeast = DevGetField(hDev, "YEAST");

				 PLC_Milk = DevGetField(hDev, "MILK");

			 ELSE

					DspError("Cannot Find Recipe " + sName);

		END

			 DevClose(hDev);

   ELSE

			DspError("Cannot open recipe database");

  END

END