>hi,
>I want to ask a favor I have a little problem, after an insert via a select sql, I have to update two fields with conditions on the same table where I do the insert, and I can not find a way to do it, here is the way insert table after
>
>idmatric year document month ncf invoice tipncf
>2001-2818 2010 c00023467 9 0 0 01
>2002-2822 2010 c00023468 9 0 0 01
>2003-2188 2010 c00023469 9 0 0 02
>2004-2518 2010 c00023410 9 0 0 01
>2005-2918 2010 c00023411 9 0 0 15
>2006-2218 2010 c00023412 9 0 0 02
>2007-2814 2010 c00023413 9 0 0 02
>2008-2812 2010 c00023414 9 0 0 02
>2009-2319 2010 c00023415 9 0 0 01
>
>I will update the invoice and ncf fields, depending on the field tipncf, information about the tables involved in this process.
>students, fees, ncfs
>
>idmatric primary students is key, tipncf is the same but in ncfs any data missing please tell me
Hi Jose,
Are you talking about SQL Server or VFP table? Can you update these two fields while inserting data?
If it's not broken, fix it until it is.
My Blog