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...

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...

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...

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...

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

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

I have been using SQL passthru to connect to my SQL Server tables for quite a while with no problem. I have a connection string encryped in a table and use it decrypted to get the connection which is stored in a variable. Since installing Office 2010 that same connection string does not work...

I want to create dynamic checkboxes on my form to accommodate the addition of a new client without having to change code. The problem I'm having is that after I programmatically create 7 checkboxes in the form init method, including one that will process all the clients, I don't know where to...

I inherited an app that has forms built using the form wizard. If I try and build the project from scratch (using just the main program and pulling in all referenced as it builds) I find that all the forms that were built with the wizard are missing. Why doesn't the builder pull them into the...

I am creating 3 workbooks, then adding data to just one workbook and formatting it. I have written an excel macro that does all this very nicely, but when I try to run it from the VFP 9 code, I get a message that the macro may not be available in this workbook or all macros may be disabled...

Does anyone know how to get the field names as the header for a listbox? I want the user to be able to scroll across the listbox and know what field values they are looking at.