Following query works flawlessly on the MAC os version but does not do anything on the iOS versions.
Result Query ‘OK’ but is not adding the data.
LocationInsertNL
SET @country = "country";
SET @zipcode = "xxxx KD";
SET @state = "state";
SET @city = "city";
SET @neighbourhood = NULL;
SET @streetname = "street name";
SET @buildingNr = 77;
SET @buildingNrAddition = NULL;
SET @floorNr = NULL;
SET @roomNr = "Some room";
INSERT INTO location
( country, zipcode, state, city, neighbourhood, streetname, buildingNr, buildingNrAddition, floorNr, roomNr)
VALUES (@country,@zipcode,@state,@city,@neighbourhood,@streetname,@buildingNr,@buildingNrAddition,@floorNr,@roomNr)
zipcode
commented
1 year ago
Following query works flawlessly on the MAC os version but does not do anything on the iOS versions. Result Query ‘OK’ but is not adding the data.
LocationInsertNL
SET @country = "country"; SET @zipcode = "xxxx KD"; SET @state = "state"; SET @city = "city"; SET @neighbourhood = NULL; SET @streetname = "street name"; SET @buildingNr = 77; SET @buildingNrAddition = NULL; SET @floorNr = NULL; SET @roomNr = "Some room";
INSERT INTO location ( country, zipcode, state, city, neighbourhood, streetname, buildingNr, buildingNrAddition, floorNr, roomNr) VALUES (@country,@zipcode,@state,@city,@neighbourhood,@streetname,@buildingNr,@buildingNrAddition,@floorNr,@roomNr)