Date field problem
I have a SQLselect command such as ;
Dim komut As String = "Select Fiyat, Tarih from Performans where Stock='" & mystock & "' and Desicion='BUY' and left(mydate,10) >='" & startingdate & "';"where mydate field is described as Date in SQL table and startingdate is calculated also as date format...However this select command does not return the values after a certain date which is given with startingdate...
Thanks in advance
could you please explain your questiononce again....Problem in datawindows fields
Yesterday I tried to explain my problem in English but It wasn't=20
understood, so I repeat my question in French if you understand it :=20
Dans une data window, j'ai 4 colonnes de commentaires saisissables par=20
l'utilisateur. Je souhaiterais que lorsque l'utilisateur arrive =E0 la fin =
premiers commentaires, sa saisie se poursuive dans le 2=B0, puis dans le 3=
etc... Je sais faire une reprise saisie sur le champ suivant mais mon pb=20
est que je ne sais pas comment d=E9tecter que l'utilisateur est =E0 la fin =
sa zone. La zone est bien d=E9...DATE field problem
I m trying to check the DATE field validation. I am trying to update this date field value in the
database and before that I have to check the validity. If there is a date value then format
it in the form and if it is not there add an empty string or add null value. I m adding the update statement also for ur ref.
If IsDate(DOB.Text) Then
DOB.Text = Format(DOB.Text, "MM/dd/yyyy")
DOB.Text = " "
strSQL = " UPDATE Persons "
strSQL += " set lngSSN ='" & SSN.Text &...Date Field Problem
I have an application that was built under PowerBuilder 6.5 and ran on
Windows 95/98. The client has rolled out Windows2000 machines now and there
is a problem with the date fields in the applicatioWhen the user tries to
enter in a date in a date field. The date field oscillates which random
numbers, and then the application crashes and closes.
The Mask of the date field is dd/mm/yyyy hh:mm and the Format of the field
is the same.
Another thing also is, there are some screens where the field has already
been populated as in:
27/02/1998 05:00, and when the user clicks on t...problem with date fields
Name: asvk sastry
Summary: problem with date fields
After entering date of birth information for usa visa application in
www.vfs-usa.co.in web page and on cliking on submit button on the page
produced undefined date char exception while the same worked well if the
same web page is loaded in Internet explorer
Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:22.214.171.124) Gecko/20061206 Firefox/126.96.36.199
...No date in Date field
I have just installed thunderbird on my system. I migrated from outlook
express. All the mail that was there before shows both the date and the
time in the date field. However, all mail received by thunderbird only has
a time stamp, no date. How do I correct this??
_Roger Bailey_ spoke thusly on 29/08/2006 10:09 PM:
> I have just installed thunderbird on my system. I migrated from outlook
> express. All the mail that was there before shows both the date and the
> time in the date field. However, all mail received by thunderbird only has
...date field = date
i made an news table and i made and option to add and update and delete news from it
i need one thing that when someone try to add news the time that he insert the news will be in teh date field of the table and dont the costumer write it
hope that u understand me
Hi, did you mean you want to add a column that get current date as its value automaticly? If so, you can do the following in Access2003:
1. add a column with 'Date/Time' data time
2. In the 'Field Properties'->'General' pannel, add a 'Default Value' for it,
3. In the 'Expression Builder', double cli...Datawindow validation with date fields
When I add datawindow validation to a datetime field eg datetime(gettext())
'year' is null or not an object.
Does anyone else get this problem?
Maybe its a locale thing as I'm in Australia and have dates set as
...Date field editmask problem
We are using 8.0.3.
I dw with a date field having a editmask of MM/DD/YYYY. If I type in
"01/01" (ie in MM/DD part of the date field )and tab out it changes to
00/00/0000 and also Itemchanged event doesnt get triggered.
Also if I type 00/00/2001 and tab out it changes to 01/01/2001 and in the
itemchanged data valus is 01/01/2001.
How I can trap these values? Is it a bug?
Thanks in Advance
Why dont you use the [date] format in the editmask instead of hardcoding
the format to mm/dd/yyyy..
In this case you will get the current regional setting of your comp...Datawindow date field does not update
I am having a strange problem with Jaguar 3.01, PB 7.01, and MS SQL Server
7.0 - I hope someone can help - this is holding up our development.
I have a datawindow with many updateable fields - one of which is a
datetime. In the datawindow painter I can update the date with no problem.
When I run - using datawindow sync - the following cases happen:
- non-date fields update with no problem (if no date field is
- SetChanges returns a -1 if non-date and date fields are modified
- if just the date field is modified sometimes I get a CORBA
S...Datawindow Date Field Behavior
PB 7.0.3 Build 10009
Has anyone else run across the following behavior that has my users
The application is basically a data entry appl,ication w/logic. The
datawindow users are keying into has numerous date fields on it. When
keying certain dates, the cursor "jumps" positions on them.
I figured out what it appears PB is doing ... for months such as April,
June, Sept. (in other words, months with only 30 days), when users key a
date such as 04/30/02, the cursor automatically jumps from the DD field to
the YY field when they enter a "3&q...Date Field problem during BCP
I have problem with Date field from the Data file during BCP.
I am loading data into the table using BCP utility.
The data file contains 3 date fields with "\t" separated delimiters.
During BCP following error message is displaying :
CSLIB Message: - L2/04/S1/N24/10
cs_convert: cslib user api layer: common library error:
The conversion/operation was stopped due to a syntax error in the
The rows from Data file are inserted into the table with different
values Ex :
Data file contains : 12/31/1999
Inserted value into the table : Dec 31 2019 12...Problem with Date fields in PB5
I'm having a problem with the date field in PB5. I have a date field on
a datawindow with the edit mask as dd/mm/yyyy and the same format is
defined for that particular field in the .db .Sometimes the date is
stored in the .db as "21/84/0001". When this happens , I can't even go
to the database and make corrections to that date field. I cannot delete
the entire row also.
If anyone have answer , please send it to me at email@example.com
.. It will be most helpful .
Sabyasachi Roy Chowdhury
Calcutta , INDIA
Are you using Win95 ? did you...Powerbuilder Date, Boolean Problem
I am running Powerbuilder 9, and have the following problem.
I have 2 instance variables defined for a user object:
The user object is basically a window. When I run the
debugger, both ib_clicked and id_old_dob appear as
29396/??/??. At various times the number has changed, but is
always in the 20000 range. These instance variables are not
used anywhere else in the application. I try setting the
ib_clicked to 'true' 'or 'false', so where is this weird
date coming from?
I had this problem with the date id_old_dob a few days...