Search results for query: *

Just spent a morning reading about LINQ in VB 2012 Unleashed. Not until I got to the third chapter devoted to this did I see that MS is no longer investing in LINQ (although it will support it (how long?)) and any new projects should avoid using it. Any comments? So, right now, what is the...

I am getting an error message "Illegal xml character" and given the exact line and column to find it. However when I look in the xml I don't see anything unusual. What would cause this error message?

Question: Given: 1. a stored procedure that updates multiple tables. 2. declare a table variable for the output clause of the first updated table 3. given that you want the same output fields for the second updated table (the first and second tables have common fields) 4. Can...

The XML looks fine. But what I have to do is load it into a temp SQL table that has a text field, then insert into the real table that has a varchar(max) field by using CAST AS VARCHAR. I'm just looking for a way to skip that step.

I've been successfully using XML to load SQL Server tables from VFP tables. However, I've hit a snag with memo fields. I mapped the memo field to a varchar(max) field in SQL Server, but all I get is one character when I migrate. I'm using CURSORTOXML(0,"xmldatatoinsert", 1,0,0) and like I said...

Thanks, everyone. This is a inhouse app and doesn't need to be perfect, just not confusiong. The ESC suggestions work great!

Thanks, Mike. And no, hopefully it will make things simpler to click the close icon on the report preview toolbar. Right now three reports are previewed in a row. When the user uses escape, the next report preview is on top but not active, so the escape doesn't work and they think they are...

Is there a way to prevent a user from using the escape button and force them to use the close button on the report preview toolbox?

OK, I'm stuck again. Have been searching all over the internet and can't figure this one out. With ActiveSheet.PivotTables("PivotTable1") .InGridDropZones = True .RowAxisLayout xlTabularRow End With Apparently, the second line has to do with Microsoft.Office.Interop.Excel, so I...

Thank you so much, will do!

So I'm stuck again with this translation: ActiveSheet.PivotTables("PivotTable1").AddDataField ActiveSheet.PivotTables( _ "PivotTable1").PivotFields("Benefit"), "Sum of Benefit", xlSum This line goes right after and I have no problem with it...

Thanks so much, all, this was very helpful.

I have a macro with the following code: ActiveWindow.SmallScroll Down:=-3 Does anyone know the translation into VFP

Thanks.

Thank you so much. I'm on it and will let you know what I find.

How can I change the path settings that are automatically set when Vista starts?

connect string is Driver={SQL Server};Server=servername;UID=myuid;PWD=mypasswrd;Database=mydb But I do think that the driver was overwritten. How would I find out? Do you know the actual file name of the SQL Server driver?

OK, here it is: LAERR Priv A getsqlconn ( 1, 1) N 1526 ( 1526.00000000) ( 1, 2) C "Connectivity error: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandl e on...

will try ....

There is no error, the connection handle is never created. It always stays -1. LPARAMETERS lpconnstring LOCAL lconn set STEP on lconn = -1 *!* ----------------------------------------------------------------------------------------------------------- *!* Connection string has been passed as...