We have one dinamic Datawindow who works Ok with/without datetime fields in Client/server mode
in Powerserver works ok, only if doesn't have datetime field.
when y click in "Guardar" it execute Update method from datawindow and i get this error
INPUT STRING WAS NOT IN CORRECT FORMAT
i attach image and datawindows with and without datetime field and datawindow syntax
Question 1: How could this solve?
I have a slight suspicion that the field format date we gave it before with DBPARMS parameters in INI file, but now all those parameters are ignored in Powerserver
Provider = 'msoledbsql19',
Identity = 'scope_identity ()',
Dateformat = 'dd/mm/yyyy'
Question 2: Could I configure the database from PowerBuilder for Powerserver without configuring the API in Snapdevelop?
thanks so much
attached script as create from sql server in a text file of the table
USE [A_NOGOYA]
GO
/****** Object: Table [dbo].[t_emp_datos] Script Date: 15/08/2023 11:49:58 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_emp_datos](
[cod] [bigint] IDENTITY(1,1) NOT NULL,
[cod_entidad] [varchar](20) NULL,
[nombre] [varchar](50) NOT NULL,
[condicion_iva] [varchar](3) NULL,
[cod_tip_documento] [varchar](4) NULL,
[nro_documento] [bigint] NULL,
[cod_ciudad] [int] NULL,
[telefono] [varchar](255) NULL,
[direccion] [varchar](50) NULL,
[fec_natal] [datetime] NULL,
[sexo] [char](1) NULL,
[e_mail] [varchar](200) NULL,
[direccion_cobro] [varchar](250) NULL,
[cod_estado_civil] [smallint] NULL,
[cuit] [bigint] NULL,
[cod_tip_instruccion] [smallint] NULL,
[tip_sangre] [int] NULL,
[fec_modificacion] [datetime] NULL,
[cod_expediente] [int] NULL,
[finalizado] [varchar](1) NOT NULL,
[es_nueva_entidad] [varchar](1) NOT NULL,
[cod_tip_entidad] [varchar](3) NULL,
[fax] [varchar](255) NULL,
[contacto] [varchar](100) NULL,
[cod_ciudad_cobro] [int] NULL,
[nro_ingresos_brutos] [varchar](15) NULL,
[cod_tip_ganancias] [smallint] NULL,
[cod_tip_ingresos_brutos] [smallint] NULL,
[cod_os_ext] [varchar](20) NULL,
CONSTRAINT [pk_t_emp_datos] PRIMARY KEY CLUSTERED
(
[cod] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[t_emp_datos] ADD DEFAULT ('N') FOR [finalizado]
GO
ALTER TABLE [dbo].[t_emp_datos] ADD DEFAULT ('N') FOR [es_nueva_entidad]
GO
ALTER TABLE [dbo].[t_emp_datos] WITH CHECK ADD CONSTRAINT [fk_t_emp_datos_cod_os_ext] FOREIGN KEY([cod_os_ext])
REFERENCES [dbo].[t_ent_datos] ([cod])
GO
ALTER TABLE [dbo].[t_emp_datos] CHECK CONSTRAINT [fk_t_emp_datos_cod_os_ext]
GO
ALTER TABLE [dbo].[t_emp_datos] WITH CHECK ADD CONSTRAINT [fk_t_emp_datos_t_ent_datos] FOREIGN KEY([cod_entidad])
REFERENCES [dbo].[t_ent_datos] ([cod])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[t_emp_datos] CHECK CONSTRAINT [fk_t_emp_datos_t_ent_datos]
GO
ALTER TABLE [dbo].[t_emp_datos] WITH CHECK ADD CONSTRAINT [fk_t_emp_datos_t_ent_datos_2] FOREIGN KEY([cod_os_ext])
REFERENCES [dbo].[t_ent_datos] ([cod])
GO
ALTER TABLE [dbo].[t_emp_datos] CHECK CONSTRAINT [fk_t_emp_datos_t_ent_datos_2]
GO
ALTER TABLE [dbo].[t_emp_datos] WITH CHECK ADD CONSTRAINT [fk_t_emp_datos_t_ent_tip_ganancias] FOREIGN KEY([cod_tip_ganancias])
REFERENCES [dbo].[t_ent_tip_ganancias] ([cod])
GO
ALTER TABLE [dbo].[t_emp_datos] CHECK CONSTRAINT [fk_t_emp_datos_t_ent_tip_ganancias]
GO
ALTER TABLE [dbo].[t_emp_datos] WITH CHECK ADD CONSTRAINT [fk_t_emp_datos_t_ent_tip_ingresos_brutos] FOREIGN KEY([cod_tip_ingresos_brutos])
REFERENCES [dbo].[t_ent_tip_ingresos_brutos] ([cod])
GO
ALTER TABLE [dbo].[t_emp_datos] CHECK CONSTRAINT [fk_t_emp_datos_t_ent_tip_ingresos_brutos]
GO
ALTER TABLE [dbo].[t_emp_datos] WITH CHECK ADD CONSTRAINT [fk_t_emp_datos_t_exp] FOREIGN KEY([cod_expediente])
REFERENCES [dbo].[t_exp_expedientes] ([cod])
ON UPDATE CASCADE
ON DELETE SET NULL
GO
ALTER TABLE [dbo].[t_emp_datos] CHECK CONSTRAINT [fk_t_emp_datos_t_exp]
GO
DDL for table t_ent_datos is missing