|
hi,
First of all check all the fields which you place on Report at design time. At run time, check whether all fields which is placed on report at design time,is present in data source ?
Can you post the code-Snippet so i can analysis properly which statement can cause error ?
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
My Company
|
|
|
|
|
How can I mass deploy our windows application (that adds information to our database) if there is no ODBC Driver on our clients PC? any suggestion on this? our database server is FileMaker(sucks!)
P.S. we have several clients all over the globe and we cannot just have them install an ODBC Driver.
In short how to have DSN less connection to FileMaker Database?
modified on Wednesday, July 9, 2008 4:25 AM
|
|
|
|
|
Why don't you add the ODBC driver setup to you own deployment?
|
|
|
|
|
yes i can do that but then i have to manually configure it one by one for the file DSN and like i said, this application will be deployed on several locations around the globe. if anybody can suggest away to create a DSN-less connection for filemaker 8, id appreciate that. 
|
|
|
|
|
You simply have no alternative. Either the FileMake ODBC drivers are installed or you're not getting a connection to the database. It's that simple.
As for a DSN-less connection, you just have to get the connection string correct. You can find an example of connecting to a FileMaker server here[^]. No DSN required.
|
|
|
|
|
I am planning to actually include the ODBC Installer in our package but encountered another problem, we are using FileMaker 8.5 and I have read from "www.filemaker.com/downloads/documentation/fm8_converting_databases.pdf" that 'The Local Data Access Companion (LDAC) and the Remote Data Access Companion (RDAC) are no longer supported.' in, i think, versions lower than Filemaker 7. Any other suggestions?
|
|
|
|
|
jalandoonkNEWBIE wrote: Any other suggestions?
Yeah. Upgrade to a database engine that IS supported, like SQL Server, Oracle, or MySQL (free).
|
|
|
|
|
yeah, in as much as i want to rant about the capabilities of Filemaker and rant( ) about our management for picking that DB engine, i guess changing my back end will be a nice solution. hehe
Thanks!
|
|
|
|
|
my application create a folder on daily basis with name as today.tolongstring (eg Monday, July 07, 2008). so how can i get on the name of yestertay folder (sunday, July 06, 2008)
if today is first day of the must how can i get yesterday value
|
|
|
|
|
How about this?
DateAdd(DateInterval.Day, -1, Today.Date).ToLongDateString
--------------------------------------------------------
Knowledge is knowing that the tomato is a fruit.
Wisdom is not putting it in fruit salad!!
|
|
|
|
|
thanks. how do i get the last day of the month in the same format
|
|
|
|
|
datetadd(day,-1,today)
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
how can i get the last and first day in a month in the format i have
i have Dim fd As New DateTime(DateTime.Now.Year, DateTime.Now.Month, 1)
fd.ToLongTimeString()
7/1/2008
MsgBox(fd)
|
|
|
|
|
What are you bone lazy our just thick  . You have been given some samples, hints and if you read some of the other answers here there is plenty of examples of date manipulation.
If you cannot work out how to get the information you need with start you have been given then give up being a programmer - you are not going to make it.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Don't call Now repeatedly. If you are unlucky (i.e. use it often enough) it will give you the wrong result, as the value may change from one call to the next.
To get the last day of the month you just add one month and subtract one day.
Dim n As DateTime = DateTime.Today
Dim first As New DateTime(n.Year, n.Month, 1)
Dim last As DateTime = first.AddMonths(1).AddDays(-1)
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Bloody hell, I've been working with the datetime object for ages and didn't know about the add***** methods. This is the other reason I lurk here.
Thanks Guffa have 5
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
thanks Guffa. mycroft holmes that been lashin has ofcourse learn from my 'lazi'. i did not phrase the probem well. i need to be able to put all folders created by my application at the end of a month in a single folder( that is first day of july,sum for june). i have been able to get the logic like is
'Dim fd As New DateTime(DateTime.Now.Year, DateTime.Now.Month, 1)
'lastday = DateAdd(DateInterval.Month, 0, fd).ToLongDateString
'If Today.ToLongDateString.Equals(lastday) Then
the move here
endif
thanks once more for your advice
|
|
|
|
|
So, what you really want is that at the beginning of a new month, you want to move all the folders of the previous month?
Something like:
Dim today As DateTime = DateTime.Today
If today.Day = 1 Then
Dim t As DateTime = today.AddMonths(-1)
While t < today
Dim folder As String = t.ToLongDateString
If Directory.Exists(folder)
' move it
End If
t = t.AddDays(1)
End While
End If
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Hi,
I dont see any value property for button. When I convert VB6 application to VB.net, the code as follows
VB 6.0
Public Property Get VarArray(ByVal ctrl As Control) As String
VarArray = ctrl.Value
End Property
After converting to VB.NET
Public ReadOnly Property VarArray(ByVal ctrl As System.Windows.Forms.Control) As String
Get
'UPGRADE_WARNING: Couldn't resolve default property of object ctrl.Value. Click for more: 'ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?keyword="6A50421D-15FE-4896-8A1B-2EC21E9037B2"'
VarArray = ctrl.Value
End Get
End Property
Here VB.NET code is giving compilation error "Value is not member of 'System.Windows.Forms.Control'"
Please let me know how to do this.
Thanks in Advance,
AR Reddy
|
|
|
|
|
You could consider going through the trouble of inheriting System.Windows.Forms.Button to create your own button control that has a Value property, but that process, although not particularly difficult, may still not be necessary. Maybe you can simply manipulate the button's Tag property in .Net to emulate how you were using the Value property?
|
|
|
|
|
A couple things:
First, the property Value on a CommandButton in VB6 is a Boolean - not a string.
Secondly, In all of VB6's infinite wisdom, doing Call Command1_Click() has the same effect of setting Command1.Value=True in code. So, the only time VarArray in your VB6 code above would be true is when Command1_Click() is called. 
If you are using RadioButtons or CheckBoxes, Value was replaced by Checked.
|
|
|
|
|
how can i retrieve end of day and end of month
|
|
|
|
|
Get the 1st day of the next month and dateadd -1
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
how do i get the 1stday of the nextmonth
|
|
|
|
|
Add a month to the 1st day of this month.
Looking at your questions, I'd suggest getting the big reference manual called Google working for you - or give up programming as you don't seem to have any concept of researching 'problems'
Bob
Ashfield Consultants Ltd
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
