powerbull2
Honrado XPZ
Ola Gostaria de saber como faço para adicionar itens do meu client no meu shop, usando o access
Toda vez que adiciono itens ou modifico apareceisso :
Warning: [obfuscated]() [function.[obfuscated]]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect in C:\Inetpub\vhosts\mupowerbull.com\httpdocs\shopping\modules\odbc.class.php on line 0
LD_Error: Não foi possivel executar: UPDATE Items SET NAME = 'Adamantine Armor', TP = 8, ID = 26, CATEGORIA = 'Armors', X = '2', Y = '3', DUR = '056', LVL = 'NO', OP = 1, LK = 1, SK = 0, ANC = 1, EXE = 2, RF = 0, JH = 3, Socket = 0, SetItem1 = 'Agnis', price = 10, priceLevel = 1, priceOption = 1, priceSkill = 1, priceLuck = 1, priceAncient = 6, priceJh = 8, priceRefine = 10, priceSocket = 10, priceOptExc = 2, maxOptExcSel = 6, ofert = 0, solds = 0, insertShop = 0, C_0 = 0, C_1 = 0, C_2 = 0, C_16 = 0, C_17 = 0, C_18 = 0, C_32 = 0, C_33 = 0, C_34 = 0, C_48 = 0, C_49 = 0, C_64 = 0, C_65 = 0, C_80 = 0, C_81 = 0, C_82 = 0, photoItem = 'images/items/nophoto.gif', photoItemAnc = 'images/items/nophoto.gif' WHERE Number = '0802600';
Toda vez que adiciono itens ou modifico apareceisso :
Warning: [obfuscated]() [function.[obfuscated]]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect in C:\Inetpub\vhosts\mupowerbull.com\httpdocs\shopping\modules\odbc.class.php on line 0
LD_Error: Não foi possivel executar: UPDATE Items SET NAME = 'Adamantine Armor', TP = 8, ID = 26, CATEGORIA = 'Armors', X = '2', Y = '3', DUR = '056', LVL = 'NO', OP = 1, LK = 1, SK = 0, ANC = 1, EXE = 2, RF = 0, JH = 3, Socket = 0, SetItem1 = 'Agnis', price = 10, priceLevel = 1, priceOption = 1, priceSkill = 1, priceLuck = 1, priceAncient = 6, priceJh = 8, priceRefine = 10, priceSocket = 10, priceOptExc = 2, maxOptExcSel = 6, ofert = 0, solds = 0, insertShop = 0, C_0 = 0, C_1 = 0, C_2 = 0, C_16 = 0, C_17 = 0, C_18 = 0, C_32 = 0, C_33 = 0, C_34 = 0, C_48 = 0, C_49 = 0, C_64 = 0, C_65 = 0, C_80 = 0, C_81 = 0, C_82 = 0, photoItem = 'images/items/nophoto.gif', photoItemAnc = 'images/items/nophoto.gif' WHERE Number = '0802600';