data, data, data
Hello, I need some advice on the best method to keep a database updated in this scenario. I have a local Solomon SQL Server where we keep our inventory. I want to build an application that will be hosted at a remote hosting location which provides a SQL database. I want to build the application to allow clients to access the inventory items and make requests based on the remote SQL data. The order will be sent to our fulfillment department via email; they will fiill the request and ship. I'm not sure the method to do this while keeping the data current on the remote and the l...How to convert varchar data type into datetime data type without data lose
i have stored date as varchar(30) data type and Date format is dd/MM/yyyy now i have to convert it into datatime data type can u help me in query ?
i have 330 records and each recod contain the Date in format of dd/MM/YYYY but due to varchar data type i can not perform calculation on Date so i have to convert into datetime without data lose.
please help me in this regard.
life is name of learning!Mark as an answer if it helps
You can check these posts
...Data Table losing data during submit command
I am populating a Data Table from a string and have a column that the user can enter a qty to receive then click the submit button. It appears that when the page is posted back to the server, the data table is cleared before the sub routine has a chance to read the data.The code is posted below: POTable is an asp table that is added to the aspx web form.________________________
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'Put user code to initialize the page here If Not (Page.IsPostBack) Then&n...Losing data
I've asked a similar question to the following in relation to another
problem, but I must now ask again, as this time the problem is elsewhere.
I would like to apologise in advance for the length of this message, I
appreciate that you are all busy people.
We have a LONG process (it currently runs for around 27 hours - Must sort
out the design) in power builder on a SQLA5.5.04 served database. The code
does not contain a COMMIT untill the very end of the process.
During this process a *lot* of data flies back and forth between the client
and the server. The problem is this:
I am using the Datawindow DTC for data entry on a page. When I type
something into a field (and don't tab off), then I ALT-TAB to another
application, and then ALT-TAB back, the data in the field is wiped
Why does this happen? Is there some way I can resolve this? I have
tried this with another design tool and this does not happen.
This has been reported as CR 208772.
This only happens in IE and not Netscape.
Dan van Leeuwen
On Thu, 11 Nov 1999 13:29:46 GMT, firstname.lastname@example.org (Jerry P)
>I am using the Datawindow DTC fo...Data or Data
I pronounce it "data". HTH
I pronounce it dAta and data. Depends upon my mood and the context it's
in. Like I preserve dAta, but i lose data. :P
> I pronounce it dAta and data. Depends upon my mood and the context it's
> in. Like I preserve dAta, but i lose data. :P
Lt Commander D "ay" ta. Nuff said. In fact he corrected Dr Pulaski
when she called him D "ah" ta. D ay ta, d ah ta, what's the
difference? One is my name... the other is not.
> Lt Commander D "ay&quo...data lose
i use this method to get my user id, and this user id will be pass around in whatever page which need it....the property function is as below....
Public Shared Property ID() As String
End GetSet(ByVal value As String)
_ID = value
but there is a problem which might cause error....sometime it return me null value....and sometime it return me correct value...
may i know how this will happen......cos this happen quite frequent in my system...
or maybe someone can provide some better solution in this case...
If i have under...ASE and ASE
Could it be possible to take scripts from ASA and load them in an ASE
Any information is welcome
ASA supports a fairly large sub-set of Transact-SQL, so if you write your
stored procedures and triggers in ASA using T-SQL, you should be able to
create scripts that will run against both ASE and ASA. If you're planning
to do this though, I would suggest developing your database schema against
ASA, since everything you write in T-SQL in ASA will be supported on ASE,
but the reverse is not true.
Check out the section in the ASA documentation entitled "Tra...Data Data :|
Ok, i have a very simple access database called score with just one table called high. This is just going to be used to keep the current score of a higher scorer and there name However, when the page loads i want the user to see this current high score and the persons name, but just one record i only ever want this to hold one record aswell..When the user finish’s the game there score is currently presented to them, when this happens i would like to connect to the database and check weather there score is higher than the current score (may have changed since they loaded page...Losing data
I recently went in thru Infomaker and added 3 columns at the end of an
existing table. Now when I perform jdbc updates thru jConnect using a
prepared statement in Java, the data in the 2 columns preceding the new
columns I added is lost (set to nulls). The table ddl is shown below
(the "outcome" fields are the new ones. The ENROLLMENTBHCOMPLETED and
CLOSUREBHCOMPLETED values are getting clobbered each time. Any ideas anyone?
CREATE TABLE AHAS.dbo.PROGRAMENROLLMENTDATA (
CLIENTIDNUMBER int not
ADMITDATE ...Problem to synchronize data with text data type between ASE and ASA
I have provided the table definition and ML log
with v+ option as follows. Thanks for your great help!
create table TBLNAME (
col1 char(3) not null ,
col2 varchar(138) not null,
col3 text null,
last_modified_dttm datetime DEFAULT getdate () not null
Below is the ML log with V+ option
I. 2010-05-06 10:23:40. SQL Anywhere MobiLink Server Version 220.127.116.116
I. 2010-05-06 10:23:40.
I. 2010-05-06 10:23:40. Copyright � 2001-2009, iAnywhere Solutions, Inc.
I. 2010-05-06 10:23:40. Portions copyright � 1988-2009, Sybase, Inc. All
rights reserve...ASE to ASE
Is anyone out there doing ASE to ASE replication using SQL remote? If
you are have created your own version of the SSEXTRACT utility to set up
a replicant database in ASE rather than ASA? Or does anyone know if
SYBASE has created a version SSEXTRACT for use with ASE to ASE
Thanks in advance
I thought the SQL Remote Replication support in ASE11.5 was meant for a
consolidate-database only (by design)! At least that was what Sybase
said when they announced support for SQL Remote technology support in
I will be happy to...utf-8 data problem with Sql Web Data Administrator
I have a database with ntext and nvarchar column. When I try to export and import data with Sql Web Data Administrator it loose it utf-8 encoding. I try to include requestEncoding=utf-8, responseEncoding=utf-8, fileEncoding=utf-8 into the web.config of Web Data Administrator but it is no use.
Can anyone show me how to do it correctly?
Thank you....How to flush ASE defualt data cache without restart ASE server?
I want to test the io of some sql.
Thanks every one!
Try running the following for each table you wish to 'flush' from cache:
-- for each table in question:
See the reference manual for more details regarding the sp_unbindcache stored proc.
> I want to test the io of some sql.
> Thanks every one!
Thank you Mark!
> Try running the following for each table you wish to
> 'flush' from cache: