Red Gate forums

help with pinvoke and variant return type

fhanggi — Mon, 15 Mar 2010 22:30:50 GMT

Could anyone please help me write a pinvoke statement for this function?

[id(0x60030004)]
HRESULT AFAccountPayment(
[in] VARIANT coForm,
[in, out, optional] BSTR* billlist,
[out, retval] VARIANT* );

I have tried a few things but it's not working. I don't know how to code the VARIAN* retval properly.
Mostly i get an error: PInvoke restriction: cannot return variants.

Here is what i have tried so far.
<DllImport("c:\windows\system32\nctk.dll")> _
Public Shared Function AFAccountPayment(ByVal coForm As Object, Optional ByRef billList As String = "") As Object
End Function

<DllImport("c:\windows\system32\nctk.dll")> _
Public Shared Function AFAccountPayment(<Out(), MarshalAs(UnmanagedType.Struct)> ByVal coForm As Object, <[In](), [Out](), MarshalAs(UnmanagedType.VBByRefStr)> Optional ByRef billList As String = Nothing) As Object
End Function

Thank you for any help.

format formally case-insensitive code

delux — Mon, 15 Mar 2010 22:02:39 GMT

We're moving from a case-insensitive to a case-sensitive SQL 2008 platform. We are not in control of the new platform and need a quick way to do a one-time update to not only keywords (which I know Refactor can already do), but also our own variables. We own Redgate Refactor, Prompt, Compare, and Backup but cannot find a way to auto-format our existing stored procs to match custom code to look like our declare variables.

Unable to decompile ASP.NET precompiled site

Nikhil Soneja — Mon, 15 Mar 2010 21:30:03 GMT

Hi,

Am consulting for a company whose source code got taken down by a malicious developer, they're left with only the contents of the web server ie; the published ASP.NET website files. The structure seems to be that each aspx page's code behind is compiled into a separate dll (of the format App_Web_{aspxfile}.{some id}.dll in addition to a number of class library DLLs....while the class libraries reflect easily, the decompilation of the code behind files doesn't go through, with the following errors (amongst others, ton of files! But the following are common)

System.NullReferenceException: Object reference not set to an instance of an object. ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 2592, offset:270 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 2587, offset:340 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 2584, offset:4181 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 2583, offset:672

OR

System.IndexOutOfRangeException: Index was outside the bounds of the array. ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 6043, offset:41 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 6031, offset:67 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 6017, offset:27 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 2927, offset:362 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 2583, offset:445

Any ideas would help! Don't need a perfect version of the source, but need to get at the logic to recode a few functions without starting from scratch if possible.

Thanks and best regards,
Nikhil

Format SQL Fails with FOR XML query

CodantiM — Mon, 15 Mar 2010 19:59:49 GMT

SQL Prompt 4.0.4.14 fails with an error saying:

"SQL Prompt was unable to format this script because some syntax errors were found while it was being parsed. These errors have been highlighted."

with this valid code:

Code:

SELECT (SELECT 'Test' FOR XML PATH(''), TYPE).value('.[1]','varchar(max)') AS Test

New version of Scream?

owenh — Mon, 15 Mar 2010 19:56:18 GMT

The 0.8 version of SQL Scream gives the following error "The database snapshot was saved by a newer version of SQL Compare" when attempting to open a snapshot created by either SQL Snapper version 8.1.2.48 or SQL Compare version 8.1.2.63.

Can the Scream utility be updated to work with the current Compare versions?

Thanks!

RE: settings for code generation from SQL Refactor

David Atkinson — Mon, 15 Mar 2010 19:27:26 GMT

Yes, that would be a great feature...

The best we can suggest for now is the workaround describe in:

http://www.red-gate.com/MessageBoard/viewtopic.php?t=9031

Once all the procedures are as per your company's style, developers should use the formatting feature as they develop. However, there's no enforcement, or ability for different developers to have different styles.

David

RE: Version number SVN labels

paul.price — Mon, 15 Mar 2010 19:19:48 GMT

David,

My shop uses SVN for source control (not VSTS). I would be happy to help out with testing on SVN. I have several ideas on how I'd like to use SQL Source Control in our multi-dba environment.

settings for code generation from SQL Refactor

paul.price — Mon, 15 Mar 2010 19:15:21 GMT

When a database is copied into SVN for the first time (initial checkin), it would be great if the settings from SQL Refactor would be used. This way you could have all your code formatted the way you prefer. In the cases where SQL Refactor is not installed, your current defaults are fine.

RE: Creating subfolders for each database

eddie davis — Mon, 15 Mar 2010 19:06:22 GMT

Thank you for your post into the forum.

To achive your goal, simply use the <database> file location tag to create a sub folder of the database name.

In the Copy To path simply add the <database> tag to the end of the path, for example:

\\MyServer\Share\<database>

This action will create a sub folder of the database name and copy the backup file into the new sub folder. Further information of the File Location Tags can be found in the SQL Backup Help Information.

I hope the above answers your question.

PROBLEM with the comparison key

randyv — Mon, 15 Mar 2010 18:29:22 GMT

I have two databases on different servers. One is a staging server where updates from the source are applied. The other is a target server, where updates to the staging server need to be applied.

"What better application for SQL Data Compare?!" says I.

So I started to use it to build a synchronization.

First problem I get, trying to set the comparison key for the first table...
Only certain columns have a checkbox, and of course the columns that really distinguish a row in the table do not have check boxes.

As this is decidedly different than what you show in the documentation, I am assuming there is a bug? If not a bug, how would I, for example, pick the Model column to be a part of the Comparison key. (note, changing options in the comparison key drop down list has no effect on the results grid - I could not select Model in either option). Also note that SQL Compare shows the tables are identical. Only difference is the staging server is running SQL Server 2K5 and the target is running SQL Server 2K8.

Is it the data type (nvarchar (max) )? If it is, there ought to be a way around this, if I were writing a script I'd substring the first 255 characters, for example. How do I do the equivalent in the GUI?

This tool would help me tremendously but I have to deal with the data types I am handed from the vendor and cannot change them. So I need to know how to deal with columns that are nvarchar(max) columns.