|
I'm not going to be able to help with the EF stuff, can't stand the tool myself, but!
A .BAK file is a backup and therefore has absolutely nothing to do with your scripting changes to the database. And cannot be used as such AFAIK.
We use Red-Gates SQL Compare to generate the change scripts, but you can create the script manually. That script then needs to be transported to and run against your clients server. You could get your app to check a folder for a .sql file on startup, if it finds one then open the file and run the script of the connection in the app. Then archive the .sql so it cannot be automatically run again.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Thank you !
For transporting this script , I think to have a one-field table inside the database . This field will keep the update script.
I want to give users only the new .exe file and the Model.Bak.
Is possible that inside my application to have a code that read this field inside the Model.Bak , get the script and run to update the current database on that computer ?
Maybe it's a stupid idea , but I want to find a way to give users only the exe file and the new Model.Bak , and they can make update process inside my program.
Thank you !
|
|
|
|
|
Just what is Model.bak and why are you supplying it with a new .exe?
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hello !
In my computer where I develop the application , I change the structure of the database when creating also the new .exe. and after I finish my application , I made a backup of the new database version. Model.bak is the new database version (empty) backup made from Sql server management Studio. I supply with the new exe , because my application has the possibility to create multiple databases and works with each of them. To create a new database the application use the Model.Bak template.
|
|
|
|
|
That is what I thought, it will not work for updating a database structure, you will restore an empty database and lose all the data.
You need to use a script to apply the changes.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I have just added functionality through a 3rd party API to a large programming project of mine. The 3rd party API requires me to set the target CPU to 64 bit for it to work on my machine.
So far so good. The section of the program which uses the API is working like a charm.
But here's the problem. Previously I was relying on API calls to SetCursorPos in another, previously totally functional part of the program. Those API calls no longer work as expected and the cursor is placed in bizarre locations when I try to call that after a 64 bit compile. If I set the target CPU back to x86 or AnyCPU, SetCursorPos works like a charm again -- but not the new 3rd party API based stuff.
I've gone searching and have found hints of other people having problems with the functionality of SetCursorPos on a x64 targeted compile, but haven't yet found any good workarounds. Thoughts?
Thanks in advance,
Frustrated in KTown
|
|
|
|
|
Sounds like you've got an incorrect P/Invoke declaration - something is declared as Integer when it should be IntPtr, or vice-versa.
According to pinvoke.net[^], the correct declaration should be:
<DllImport("user32.dll", SetLastError:=True)> _
Private Shared Function SetCursorPos(ByVal X As Integer, ByVal Y As Integer) As Boolean
End Function
If you're using Windows Forms, there's a managed API which might work better:
https://msdn.microsoft.com/en-us/library/system.windows.forms.cursor.position%28v=vs.110%29.aspx[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I created an access Lyric database. Then I added a table and a combo to hold song file data. Then, when the user selects a song and clicks play the code below gets executed. When I first did this it went well. WMPlayer opened up and played the song. Now it opens up the open dialog wanting me to select the file. It returns a 42. This is the first time I used this API command. Any help will be appreciated.
Private Sub cmdPlay_Click()
Const klShowApp As Long = 1
Dim sPath As String, sFile As String
Dim lReturn As Long
On Error GoTo ERR_cmdPlay_Click
sFile = ksQuote & Me.cboTuneLU.Column(1) & ksQuote
sPath = ksQuote & Me.cboTuneLU.Column(2) & ksQuote
lReturn = ShellExecute(Me.hWnd, "open", sPath, vbNullString, sFile, klShowApp)
Stop
EXIT_cmdPlay_Click:
Exit Sub
ERR_cmdPlay_Click:
ShowError "frmLyrics.cmdPlay_Click"
Resume EXIT_cmdPlay_Click
End Sub
modified 28-Jan-15 15:11pm.
|
|
|
|
|
|
The user actually selects the filespec (path & filename) from the open dialog box. I split the filespec into Path and filename and store each into their corresponding fields in a record. I know the path is correct because the open dialog opens to the correct folder. This was working great, but now It does this. I would sure like to find out what the return values of this API function mean. I tried every number fro 0 to 10 in the show parameter of the shellexecute API call.
The record is define as:
tblMP3
------
MP3Seq autonum index
MP3ID long
MP3VerID integer
MP3Path text
MP3File text
I wanted to be able to save more then one song file. The artist's version and a karaoke version. That's what the MP3VerID is for.
The MP3ID field is the same as the autonum field in the lyrics table.
I have had this program for a number of years. VB's Shell has been used all this time. But now on Win 7 I get a security message blocking me from using it. That's when I discovered ShellExecute.
Any help will be appreciated Roger
|
|
|
|
|
It's an exit code. usually 0 means all is good. 1 means error. But search for Windows Media Player Exit Codes.
You should load Quicktime, set it as default player, and give it a test first, before you tear your hair out.
|
|
|
|
|
Hi,
I am a newbie
I have problem with string builder. I want to show to Richtextbox in vb with Richtextbox template
ex. :
Jan 674 Meet 670 Not Meet 4
Feb 635 Meet 631 Not Meet 4
etc.
with source from datagirdview with 8 columns and xxxx rows.
for ex. columns are : Registered Date, Deadline Date, Month, Meet/Not Meet,etc.
This my Code :
For Each keyvalue As KeyValuePair(Of String, Integer) In DicMonth
CMonth.Items.Add(String.Format("{0}", keyvalue.Key))
sb.AppendLine(String.Format("{0} : {1}", UCase(keyvalue.Key), keyvalue.Value))
Next
For Each keyvalue1 As KeyValuePair(Of String, Integer) In DicMeetTotal
sb.AppendLine(String.Format("{0}", "MEET : " & keyvalue1.Value))
Next
RichTextBox2.Text = sb.ToString
and the result is :
JAN : 674
FEB : 635
MAR : 623
APR : 637
MAY : 888
JUN : 994
JUL : 452
AUG : 594
SEP : 526
NOV : 317
DEC : 305
MEET : 670
MEET : 631
MEET : 621
MEET : 637
MEET : 870
MEET : 968
MEET : 438
MEET : 583
MEET : 522
MEET : 287
MEET : 298
Please help me ?
I appreciate your help 
|
|
|
|
|
You are creating all the month items first, and then all the MEET items. You need to combine your loops somehow so it selects both items together, i.e. (MONTH and number, MEET and number).
|
|
|
|
|
Thanks for your advice but I had already creating both of them.
please tell me how to combine it ?
Thanks
|
|
|
|
|
You need to match the entries in the two dictinaries so you get them in the correct order, probably by using an index value and a single loop.
|
|
|
|
|
I have no idea for this, could you give me a sample ?
Thanks for your help
|
|
|
|
|
I cannot see an easy way of doing what you want, and I don't know where the original data comes from. It would be better if you found a way of getting all the values together rather than the two disconnected dictionaries.
|
|
|
|
|
Hi
I am trying to capture a pic from an ip camera in VB6,
i have been told it uses onvif
has anyone got any ideas or sample code that i could look
at.
Regards
Trevor
|
|
|
|
|
I haven't used VB6 in a very long time as its a depreciated language.
but a quick google brings back these VB6 IP Camera example[^]
Every day, thousands of innocent plants are killed by vegetarians.
Help end the violence EAT BACON
|
|
|
|
|
Hi Simon
thnaks a mil, i will give it a bash
Regards
Trevor
|
|
|
|
|
Hi Simon
That was a big help, i only have one small problem
i need to find LNCActivex.ocx. the link to install it doesnt work.
I have searched the net and find plenty of apps that want to check all your files
and tidy them up.
Any idea where i could find it ?
Thanks a mil.
|
|
|
|
|
|
HI Simon
Thanks for that, i will have a look. hopefully it works.
Regards
Trevor
|
|
|
|
|
Hi Simon
sorry to bug you.
I tried that, it seems to install someting on my pc but no sign
of LNCActiveX.
I have tried looking elsewhere but nothing.
Any other idead,
regards
Trevor
|
|
|
|
|
Sir can you send me source
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
