UrUbUs Posted October 20, 2007 at 05:59 PM Report Share #141621 Posted October 20, 2007 at 05:59 PM Boas People, Como é que se gravam dois campos exclusivamente numa tabela com vários campos? o código que eu fiz foi este: query2 = query2 & " values('" & declaraçao_medica & "'," query2 = query2 & "'" & gNumSocio & "'" query2 = query2 & ")" Cumprimentos Link to comment Share on other sites More sharing options...
Betovsky Posted October 20, 2007 at 06:03 PM Report Share #141623 Posted October 20, 2007 at 06:03 PM A não ser que os restantes campos da tabela permitam null ou tenham um valor default isso vai dar estrilho. "Give a man a fish and he will eat for a day; Teach a man to fish and he will eat for a lifetime. The moral? READ THE MANUAL !" Sign on a computer system consultant's desk Link to comment Share on other sites More sharing options...
NuGuN Posted October 21, 2007 at 04:31 AM Report Share #141706 Posted October 21, 2007 at 04:31 AM UrUbUs, agradecia que as regras desta secção fossem lidas 😉 (qual a linguagem que estas a utilizar?) Cumps Link to comment Share on other sites More sharing options...
Tiago Salgado Posted October 21, 2007 at 06:01 PM Report Share #141873 Posted October 21, 2007 at 06:01 PM Betovsky, agradecia que as regras desta secção fossem lidas 😉 (qual a linguagem que estas a utilizar?) Cumps Deves-te ter enganado no nome 🙂 Boas People, Como é que se gravam dois campos exclusivamente numa tabela com vários campos? o código que eu fiz foi este: query2 = query2 & " values('" & declaraçao_medica & "'," query2 = query2 & "'" & gNumSocio & "'" query2 = query2 & ")" Cumprimentos Como o Betovsky disse, se tiveres campos alem desses que queres gravar que nao permitem valores nulos entã vai-te dar barraca. Já agora, essa forma que usas para construir a tua query é bastante má. Usa os parametros do SqlCommand (assumindo que estas a trabalhar com vb.net). Link to comment Share on other sites More sharing options...
NuGuN Posted October 21, 2007 at 06:59 PM Report Share #141922 Posted October 21, 2007 at 06:59 PM pois foi 🙂 Obrigado pelo reparo 🙂 Cumps Link to comment Share on other sites More sharing options...
Asgorath Posted October 22, 2007 at 08:34 AM Report Share #142041 Posted October 22, 2007 at 08:34 AM E se estas a usar MS SQL SERVER 2000/2005 podias usar stored procedure. "The Dark Side Clouds Everthing. Impossible To See The Future Is."My rig: Intel Core 2 Quad Q9450 | abit IP35P | 4G Kingston 800 Mhz | XFX GeForce 9800 GX2 1G ddr3 | 2X WD5000AAJS 500Gb Sata 2 | PSU 600W || Caixa El-Diablo | Creative XMod Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now