Categories
Mastering Development

Is it Possible to create external table with options delimiter?

I want to create external table in greenplum : CREATE EXTERNAL TABLE hctest.ex_abs ( a text, b text, c text, d text, e text, f text ) LOCATION (‘gpfdist://192.168.56.111:10000/abs31032020.csv’) FORMAT ‘CSV’ (DELIMITER ‘,’ HEADER); But the value in file abs31032020.csv is like this : Employee ID,Time Type,Start Date,End Date,Number Of Days,Comment 90007507,Leave,05/08/2020,05/08/2020,1,”dear mas Andria, kindly […]

Categories
Mastering Development

How to count working days in Android Studio?

What I want to do is calculate working days from two defined dates (beginning of month and end of the month). I am working with a function that I found out which receives three parameters, start date, end date, and a list of dates of non-working days (holidays and others). The code below gives me […]

Categories
Development JSON Swift

Swift Function Not Continuing after completion of Json Decoder within – “else if” issue?

I am using this function to call json information from a database – it gets the information fine. But it does not continue after the “getHistoricalMonthlyData”. so it will not get to the print(“****** line 55”). (yes, I plan on making this a func once I figure out the issue.) it will print the “print(i.stock)” […]

Categories
Development Google

Script that will email data from Google Sheets

I created a script to email data from a particular range in a Google sheet, but the data runs together. What changes do I need to make to my script so the data is arranged in separate lines in the email body or a table format? Data is in cells A5:B16 and is actually formulas […]

Categories
Development

How to create SQL that uses input from a Multi-select list in MS Access

I have an SQL query that creates output for a form based on a few selected inputs; start date, end date, store location, and it works fine. However, I need to change the store location selector from a single selection comboBox to a multi-selection listBox. In the former, I simply reference the comboBox field to […]

Categories
Development

How to create SQL that uses input from a Multi-select list in MS Access

I have an SQL query that creates output for a form based on a few selected inputs; start date, end date, store location, and it works fine. However, I need to change the store location selector from a single selection comboBox to a multi-selection listBox. In the former, I simply reference the comboBox field to […]

Categories
Development MySQL

How i can allow user to input “empty” for integer columns in Jtable and mysql table?

I want allow the user to pass some optional data in the input like: salary, Graduation year are int type Hiring Date, End Date, Birth Date are str type How can I avoid this, and allow mysql Entry? public class Employee implements mainData{ private int EmpNo; private String EmpName; private String HireDate; private String EndDate; […]

Categories
Development

Extract heart rate code in swift using iwatch

Im using the below code to extract heart rate, but when i use it inside my custom class , it says that self.heartRateQuery is not defined inside the class.and its correct coz in my class there is no heartRateQuery. Im new to swift. can you please tell how to deal with this ? i just […]

Categories
Development

Array send to empty data into procedure

I was sending array into procedure through following codes. But some magic happens and array is always send empty into Oracle db. oracle.jdbc.OracleConnection connection = (OracleConnection)Jdbc.getInstance().createConnection(); //INstead of xxxx is real number String [] name = new String[]{“XXXXXXXXXXXXXXXXXXXX”}; ArrayDescriptor arrDec = ArrayDescriptor.createDescriptor(“ARRAY_VARCHAR2”,connection); Array array = new Array(arrDec,connection,name); CallableStatement call = connection.prepareCall({call acc_statement(?,?,?,?)}); call.setData(1,date); call.setDate(2,date); call.setArray(3,array); […]